On 5 October 2010 12:06, Tim Uckun <timuckun@xxxxxxxxx> wrote: > On Tue, Oct 5, 2010 at 11:38 PM, Thom Brown <thom@xxxxxxxxx> wrote: >> On 5 October 2010 10:20, Tim Uckun <timuckun@xxxxxxxxx> wrote: >>> The database machine is a linode host. >> >> Good choice ;) >> >> Obvious question, but I'll ask it: Have you run ANALYZE or VACUUM >> ANALZYE on the database? Also being able to see the query plan would >> help. >> > > I did run vacuum analzye on the table I created. The other table I > presume is auto vacuumed since that is on. I'd still recommend manually running ANALYZE on any involved tables, just in case. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
