From: tv@fuzzy.cz
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query Performance SQL Server vs. Postgresql
Date: Sun, 21 Nov 2010 16:56:59 +0100
Message-ID: <cbf56bcd349aaa08e45ed9dfe42c3545.squirrel@sq.gransy.com> (raw)
In-Reply-To: <4CE8E4FC0200002500037C84@gw.wicourts.gov>
References: <4CE8E4FC0200002500037C84@gw.wicourts.gov>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz, Kevin.Grittner@wicourts.gov
Subject: Re: Query Performance SQL Server vs. Postgresql
In-Reply-To: <cbf56bcd349aaa08e45ed9dfe42c3545.squirrel@sq.gransy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox