Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT DISTINCT triggers sorting operation - Mailing list pgsql-general

From Scott Marlowe
Subject Re: SELECT DISTINCT triggers sorting operation
Date
Msg-id dcc563d11002061947g31c49c78v5d34c122d1fcebc4@mail.gmail.com
Whole thread Raw
In response to SELECT DISTINCT triggers sorting operation  (Gaëtan Allart <gallart@free.fr>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Scott Mead
Date:
Subject: Re: Snow Leopard-how to get PG 8.4 to start up on demand?
Next
From: Tom Lane
Date:
Subject: Re: Multiple buffer cache?