Re: Query slow after VACUUM ANALYZE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gdh(at)eyjar(dot)is
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query slow after VACUUM ANALYZE
Date: 2005-09-06 03:53:41
Message-ID: 14135.1125978821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

gdh(at)eyjar(dot)is writes:
> Any ideas what I can do to make the query running in < 10 seconds?

Increase work_mem (or sort_mem in older releases). PG is dropping
back from the hash plan because it thinks the hashtable won't fit
in work_mem.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message J. Andrew Rogers 2005-09-06 07:03:29 Re: Postgresql Hardware - Recommendations
Previous Message Christian.Kastner 2005-09-05 13:50:07 Postgresql Hardware - Recommendations