Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: SELECT DISTINCT triggers sorting operation
Date
Msg-id 18678.1265524736@sss.pgh.pa.us
Whole thread Raw
In response to SELECT DISTINCT triggers sorting operation  (Gaëtan Allart <gallart@free.fr>)
Responses Re: SELECT DISTINCT triggers sorting operation  (Gaëtan Allart <gallart@free.fr>)
List pgsql-general
Tree view 
=?iso-8859-1?Q?Ga=EBtan_Allart?= <gallart@free.fr> writes:
> 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.

Did you ANALYZE the database after loading it?  Are you sure you
have all the parameters set similarly to what you used in the 8.3
installation?

(The described behavior sounds suspiciously like work_mem is not
large enough to allow a hashagg to be chosen.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple buffer cache?
Next
From: Gaëtan Allart
Date:
Subject: Re: SELECT DISTINCT triggers sorting operation