Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow first query despite LIMIT and OFFSET clause - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Slow first query despite LIMIT and OFFSET clause
Date
Msg-id dcc563d10901252307p1c215f32s23fb6fe52beeaacd@mail.gmail.com
Whole thread Raw
In response to Re: Slow first query despite LIMIT and OFFSET clause  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
Tree view 
On Mon, Jan 26, 2009 at 12:06 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> On Mon, Jan 26, 2009 at 3:04 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
>>> Hi Scott. Yes, there is an autovacuum on both the tables. Should i
>>> additionally do a manual vacuum too?
>>
>> Nah, just an analyze.  what version of pgsql is this, btw?
>>
>
>
> Actually both vacuum and analyze happen at regular intervals. Are they
> not doing their job?

Hard to say.  You could try increasing your stats target on the fields
where the approximation is way off.

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Slow first query despite LIMIT and OFFSET clause
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: where (x,y,z) in ((x1,y1, z1), (x1,y1, z1), (x1,y1, z1), (x2,y2, z2)) (not) optimized