Re: Query Performance SQL Server vs. Postgresql

Поиск
Список
Период
Сортировка
От tv@fuzzy.cz
Тема Re: Query Performance SQL Server vs. Postgresql
Дата
Msg-id cbf56bcd349aaa08e45ed9dfe42c3545.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: Query Performance SQL Server vs. Postgresql  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Дерево обсуждения 
> 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Should changing offset in LIMIT change query plan (at all/so early)?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum blocks the operations of other manual vacuum