RE: Really SLOW using GROUP BY ...!? - Mailing list pgsql-general

From Mikheev, Vadim
Subject RE: Really SLOW using GROUP BY ...!?
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3161@sectorbase1.sectorbase.com
Whole thread Raw
In response to Really SLOW using GROUP BY ...!?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-general
> > somehow. Also, use -S 2048 (or more) backend arg to increase sort
> > memory size.
>
> I'm using -S 512000 ;))

512Mb?! Isn't it tooo much?

> The result I have is not good ;)
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> :(
>
> So I vacuum analyze my table ...
>
> Then I get : exactly the same result : about 3 min !

Seems we have to wait new aggr + group implementation, sorry -:(

Vadim

pgsql-general by date:

Previous
From: Hervé Piedvache
Date:
Subject: Re: Really SLOW using GROUP BY ...!?
Next
From: Mathieu Arnold
Date:
Subject: bug ?