| From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
|---|---|
| To: | "'herve(at)elma(dot)fr'" <herve(at)elma(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | RE: Really SLOW using GROUP BY ...!? |
| Date: | 2000-11-08 22:07:27 |
| Message-ID: | 8F4C99C66D04D4118F580090272A7A234D3161@sectorbase1.sectorbase.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Curley | 2000-11-08 22:20:29 | Re: [NOVICE] Re: VACUUM AND VACUUM ANALYSE |
| Previous Message | Hervé Piedvache | 2000-11-08 21:43:33 | Re: Really SLOW using GROUP BY ...!? |