Re: SELECT DISTINCT triggers sorting operation

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Gaëtan Allart <gallart(at)free(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT DISTINCT triggers sorting operation
Date: 2010-02-07 03:47:40
Message-ID: dcc563d11002061947g31c49c78v5d34c122d1fcebc4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Feb 6, 2010 at 3:49 PM, Gaëtan Allart <gallart(at)free(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-02-07 06:35:36 Re: Multiple buffer cache?
Previous Message Scott Mead 2010-02-07 03:07:16 Re: Snow Leopard-how to get PG 8.4 to start up on demand?