On Wed, Oct 17, 2012 at 1:53 AM, Martin French <Martin.French@xxxxxxxxxxxxx> wrote: Thanks for your response. > What are the settings for: > work_mem 100MB > maintenance_work_mem 64MB > How many concurrent connections are there? ~20 > Have you ran explain analyze on the query that doesn't crash (i.e the old > box) to get the exact execution plan? I can try that in the morning, but I didn't think this was relevant. I know cost estimates can be off, but can the plan actually change between a vanilla explain and an explain analyze? > Has the DB been vacuum analyzed? Not outside of autovacuum, no, but it's actually a former replica of the first database (sorry I neglected to mention this earlier). -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance