On Tue, Oct 5, 2010 at 11:38 PM, Thom Brown <[email protected]> wrote: > On 5 October 2010 10:20, Tim Uckun <[email protected]> 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 can get you the plan but I don't think it would help because the result table is now blank. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
