Re: SELECT DISTINCT triggers sorting operation

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: SELECT DISTINCT triggers sorting operation
Дата
Msg-id dcc563d11002061947g31c49c78v5d34c122d1fcebc4@mail.gmail.com
обсуждение исходный текст
Ответ на SELECT DISTINCT triggers sorting operation  (Gaëtan Allart <gallart@free.fr>)
Список pgsql-general
On Sat, Feb 6, 2010 at 3:49 PM, Gaëtan Allart <gallart@free.fr> wrote:
> Hi everybody,
>
> I'm experiencing an interesting issue with PostgreSQL 8.4.2-r2.
> I was running a pretty big database on another server (8.3) pretty fine.
> When I moved it to this new server, behaviour changed.

What does explain analyze run on both the 8.3 and 8.4 say?

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Mead
Дата:
Сообщение: Re: Snow Leopard-how to get PG 8.4 to start up on demand?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Multiple buffer cache?