6,740 reputation
31438
bio website
location Berlin, Germany
age 38
visits member for 2 years, 9 months
seen 20 hours ago

Feb
4
comment How to efficiently model this simple data structure?
Why the quotes? WHere is it from?
Feb
4
comment Why one database is so much slower than other?
Please post the respective results of EXPLAIN ANALYZE. Underlying table definitions (with indexes) are also needed.
Feb
2
comment How do I add/remove tables to a Windows Azure database?
How about asking your colleague? (Well, I see it's weekend just now.)
Feb
1
comment Get counts grouped by month and year
Could you give an explanation, too? It is very welcome on this site.
Feb
1
comment Granting access to all tables for a user
This will add the following privileges on the database: CREATE, CONNECT, TEMPORARY. No privileges on tables.
Feb
1
comment Granting access to all tables for a user
Welcome to dba.se! Code-only answers are discouraged here since the 'why's are usually at least as important as 'how's. You can add explanation, links to documentation etc. in order to produce a good answer. Thanks in advance!
Feb
1
comment compare the same table
Could you attach the execution plan and the definition of your indexes (if any)? And the DISTINCT in the subquery is useless (I think it causes a useless sort, which is not good).
Feb
1
comment Trying to create a sequence in Oracle that starts with the max value of primary key of a specific table. Why does this not work?
'This does not work' is hardly an error code in any system. What's more, it does not describe your problem at all. Do you get an error? Or you get a sequence with the wrong values? Or?
Jan
30
comment In DBMS binary relationship is better than ternary
Could you give an example where you'd find a ternary relationship necessary?
Jan
30
comment What is the correct result for this query?
May I ask where did you find the standard? If you say 'on my bookshelf' I'll be disappointed :)
Jan
30
comment optimize this query
Firstly, between 'please' and 'pls' the difference is only 3 letters. I'll give them to you free of charge. (Read: please, post well-formed questions only if you want to be polite to others.) Otherwise there are missing information: table structure (including indexes), execution plan and time, RDBMS and so on.
Jan
29
comment postgresql out-of-memory
Please report your findings!
Jan
29
comment postgresql out-of-memory
Also, on Windows, large values for shared_buffers aren't as effective. You may find better results keeping the setting relatively low and using the operating system cache more instead. The useful range for shared_buffers on Windows systems is generally from 64MB to 512MB. I'd start from lower, with both values. If and only if I hit the limits of the settings I'd raise those. If your biggest table is 200 MB, then 1 G for maintenance_work_mem sound like a waste.
Jan
29
comment postgresql out-of-memory
Check carefully the linked doc page, it says that on Windows the shared_buffers param is better set lower. Allocating half the memory to PG is not very wise anyway, given that the OS and other software need memory too.
Jan
29
comment postgresql out-of-memory
Then let me try from the other end: how big is your biggest table? Anyway, a possible solution could be temporarily lowering shared_buffers while you are restoring, then raise it back and lower maintenance_work_mem.
Jan
29
comment postgresql out-of-memory
How big is your biggest index?
Jan
29
comment postgresql out-of-memory
Check the maintenance_work_mem description in the documentation. This size (relative to the remaining portion) seems overkill. How do your typical queries look like? How much memory do they consume?
Jan
29
comment postgresql out-of-memory
Operating system? Size of physical memory? Swap? Other software running on the same box? Without knowing these we could blame the aliens as well :)
Jan
28
comment PostgreSQL 8.3: Slow GROUP BY on large table
In PostgreSQL 9.2 it could use an index (and presumably be faster). Your version is quite old, maybe this is the time for upgrading?
Jan
27
comment Query optimization or missing indexes?
Have you ANALYZEd your tables recently? The estimated and real row counts differ significantly. And an other observation: the topmost row indicates that there are no rows affected (actual rows=1). How does the plan look like if it really does something? What would be the desirable execution time?