On Tue, Oct 5, 2010 at 11:38 PM, Thom Brown <t...@linux.com> wrote: > On 5 October 2010 10:20, Tim Uckun <timuc...@gmail.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
