> Pavel Stehule wrote:
>> 2010/11/21 Humair Mohammed :
>>> shared_buffers = 2
>> shared_buffers = 2 ???
> Yeah, if that's not a typo, that's a very serious misconfiguration.
I guess that's a typo, as the explain plain in one of the previous posts
Buffers: shared hit=192 read=4833
for a sequential scan. But I still don't know why is the query so slow :-(
In response to
pgsql-performance by date
|Next:||From: Alvaro Herrera||Date: 2010-11-21 16:25:37|
|Subject: Re: autovacuum blocks the operations of other manual vacuum|
|Previous:||From: Kevin Grittner||Date: 2010-11-21 15:44:21|
|Subject: Re: Should changing offset in LIMIT change query plan (at all/so early)?|