Re: [PERFORM] Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)

2007-01-15 Thread HA/EXA
> -Original Message- > From: Dave Dutcher [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 14, 2007 5:12 PM > To: Rolf Østvik (HA/EXA); pgsql-performance@postgresql.org > Subject: RE: [PERFORM] Problem with grouping, uses Sort and > GroupAggregate, HashA

Re: [PERFORM] Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)

2007-01-14 Thread HA/EXA
Computer: Dell PowerEdge 2950 openSUSE Linux 10.1 Intel(R) Xeon 3.00GHz 4GB memory xfs filesystem on SAS disks > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Rolf Østvik (HA/EXA) > Sent:

[PERFORM] Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)

2007-01-14 Thread HA/EXA
(now with a more sensible subject) I have been trying to change a many parameters on server versions 7.4.15, 8.1.4, 8.2.0 and 8.2.1. I still hope a have managed to keep my head straigth and that i do not present to much faulty information. The cost estimates generated by the different server vers

[PERFORM]

2007-01-14 Thread HA/EXA
12345678901234567890123456789012345678901234567890123456789012345678901234567890 0011223344556677 I have been trying to change a many parameters on server versions 7.4.15, 8.1.4, 8.2.0 and 8.2.1. I still hope a have managed to keep my