Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Performance SQL Server vs. Postgresql - Mailing list pgsql-performance

From tv@fuzzy.cz
Subject Re: Query Performance SQL Server vs. Postgresql
Date
Msg-id cbf56bcd349aaa08e45ed9dfe42c3545.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: Query Performance SQL Server vs. Postgresql  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
> 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
contains

   Buffers: shared hit=192 read=4833

for a sequential scan. But I still don't know why is the query so slow :-(

regards
Tomas

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Should changing offset in LIMIT change query plan (at all/so early)?
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum blocks the operations of other manual vacuum