> > 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