10,382 reputation
11236
bio website
location Munich
age
visits member for 2 years, 11 months
seen 10 mins ago

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


5h
revised SqlServer Permission
edited tags
9h
revised what values to set for the folowing PostgreSQL Variable
added 8 characters in body
1d
revised Index is not used with same Query on two Servers
edited tags
1d
comment ORA-30009: Not enough memory for CONNECT BY operation
None of those tips will reduce the memory required by a connect by query.
1d
comment ORA-30009: Not enough memory for CONNECT BY operation
Please show us the query and the execution plan.
1d
comment PostgreSQL DB size increasing after restoring the same database backup
A pg_restore will only delete data if you use the --clean switch. I'm surprised you didn't get a bunch of errors when you tried to restore the data into the same database.
1d
comment PostgreSQL DB size increasing after restoring the same database backup
You are not dropping the old DB or at least the old tables. If your tables don't have a primary or unique key (which would be very bad) then I guess it's possible that a restore into the same DB will just add the rows from the backup
1d
revised PostgreSQL DB size increasing after restoring the same database backup
added 50 characters in body
1d
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.
2d
comment postgresql being slow on count distinct for dates
wiki.postgresql.org/wiki/Slow_Query_Questions
2d
comment Get first login-Hit on huge table
What's unclear about the error message?
2d
revised Get first login-Hit on huge table
edited tags
2d
reviewed Approve suggested edit on neo4j tag wiki
2d
reviewed Approve suggested edit on neo4j tag wiki excerpt
2d
reviewed No Action Needed What's the best way to translate a website
2d
comment Get first login-Hit on huge table
Which DBMS are you using? Postgres? Oracle? How does the execution plan look like?
2d
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
2d
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?