Mat wrote:
Lines from postgresql.conf that don't start with a '#':

tcpip_socket = true
shared_buffers = 126976         #992 MB
sort_mem = 36864                #36 MB
vacuum_mem = 73696              #72 MB

I would suggest scale down shared buffers to 128 or 64MB and set effective cache size correct. That should help.


HTH

Shridhar


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to