10,402 reputation
11437
bio website
location Munich
age
visits member for 2 years, 11 months
seen 3 hours ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


Apr
16
revised PostgreSQL DB size increasing after restoring the same database backup
added 50 characters in body
Apr
16
comment Can comments in stored procedures cause problems
I have seen situations where such comments caused trouble (it's been a while, can't recall the exact circumstances). After using block comments /* ... */ instead of line comment things were OK.
Apr
15
comment postgresql being slow on count distinct for dates
wiki.postgresql.org/wiki/Slow_Query_Questions
Apr
15
comment Get first login-Hit on huge table
What's unclear about the error message?
Apr
15
revised Get first login-Hit on huge table
edited tags
Apr
15
reviewed Approve suggested edit on neo4j tag wiki
Apr
15
reviewed Approve suggested edit on neo4j tag wiki excerpt
Apr
15
reviewed No Action Needed What's the best way to translate a website
Apr
15
comment Get first login-Hit on huge table
Which DBMS are you using? Postgres? Oracle? How does the execution plan look like?
Apr
15
comment How slow is slow in postgres?
hash indexes are pretty much "discouraged" - you are probably better off using a b-tree index instead. Plus, if you have many NULL values in your table using a partial index on group_a IS NOT NULL might help considerably. Adding a to the index definition might help with the group by. With such a big table you almost certainly want to increase work_mem drastically
Apr
14
comment Trigger needs dbms_alert declared
Privileges received through roles are not in effect in PL/SQL code. You need to grant the execute privilege directly to the owner of the trigger
Apr
14
comment Select one single row from table b for each row from table a
What indexes do you have on the table? What does the execution plan look like?
Apr
14
reviewed Reject suggested edit on Will {fn concat} work without issue in MySQL, SQL Server and Oracle?
Apr
13
comment How slow is slow in postgres?
wiki.postgresql.org/wiki/Slow_Query_Questions
Apr
11
revised How does InnoDB store tables in ibdata file?
deleted 129 characters in body; edited title
Apr
11
revised Is PostgreSQL or ElasticSearch/Solr the right tool for this kind of query?
added 46 characters in body
Apr
11
revised Sort Totals By Months
edited tags
Apr
11
comment Best suited combination of Oracle, JDK & OJDBC
Check the FAQ: oracle.com/technetwork/database/enterprise-edition/…
Apr
11
revised Best suited combination of Oracle, JDK & OJDBC
deleted 8 characters in body
Apr
11
comment Oracle Historical Session Information
What is your question?