Re: Trying to figure out why these queries are so slow - Mailing list pgsql-general

From Tim Uckun
Subject Re: Trying to figure out why these queries are so slow
Date
Msg-id AANLkTikyU0pkGvUCnWbke9Gf8yBGvB+tzEf1TVAtD059@mail.gmail.com
Whole thread Raw
In response to Re: Trying to figure out why these queries are so slow  (Thom Brown <thom@linux.com>)
Responses Re: Trying to figure out why these queries are so slow  (Thom Brown <thom@linux.com>)
List pgsql-general
On Tue, Oct 5, 2010 at 11:38 PM, Thom Brown <thom@linux.com> wrote:
> On 5 October 2010 10:20, Tim Uckun <timuckun@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.

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Trying to figure out why these queries are so slow
Next
From: Thom Brown
Date:
Subject: Re: Trying to figure out why these queries are so slow