Re: Running update in chunks?

On 01/21/2013 03:45 PM, Tim Uckun wrote:
> Oh I forgot
> ...
> "shared_buffers";"1600kB";"configuration file"

You *reduced* shared buffers to 1.6MB? IIRC the typical default is 32MB 
and the most common adjustment is to *increase* shared buffers. Most of 
my servers are set to 2GB.

Try bumping that up to a reasonable value 
(http://www.postgresql.org/docs/9.2/static/runtime-config-resource.html) 
and share the results. Don't forget to restart PG after changing that 
setting.

Cheers,
Steve