6,639 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 7 months
seen 4 mins ago

Jan
30
reviewed Reviewed Which Database to choose: MySQL or Oracle
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
revised optimize this query
deleted 6 characters in body; edited title
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
30
reviewed Reviewed How to create two database copies in two users from same dump file
Jan
30
reviewed Reviewed mongodb heartbeat - unicast, broadcast or multicast?
Jan
30
revised one trigger for multiple tables
added 344 characters in body
Jan
30
answered one trigger for multiple tables
Jan
29
reviewed Reviewed Use GIN to index bit strings
Jan
29
reviewed Reviewed How can I use mongoDB efficiently in this scenario?
Jan
29
reviewed Approve suggested edit on Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
Jan
29
reviewed Reject suggested edit on Writing a simple bank schema: How should I keep my balances in sync with their transaction history?
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
reviewed No Action Needed Encrypt/Decrypt output & input for SSIS task
Jan
29
comment postgresql out-of-memory
How big is your biggest index?
Jan
29
reviewed Reviewed Can't Login to SQL Server 2008 when running single user mode
Jan
29
reviewed No Action Needed DB2 passwords with special characters