Robert Creager <[EMAIL PROTECTED]> writes:
> Thanks for the hint. I just upped my shared_buffers to 8192, fsm_relations to
> 10000, fsm_pages to 100000, sort_mem to 64000, and an UPDATE which was taking over 2
> hours dropped down to 1 to 2 minutes!
Cool ... but it's not immediately obvious which of these changes did the
trick for you. What settings were you at before? And what's the
details of the problem query?
The first three settings you mention all seem like reasonable choices,
but I'd be hesitant to recommend 64M sort_mem for general use (it won't
take very many concurrent sorts to drive you into the ground...). So
I'm interested to narrow down exactly what was the issue here.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
