[PERFORM] HashAggregate slower than sort?

2010-06-18 Thread Jatinder Sangha
Hi, I've noticed something that I find strange with the hash-aggregate feature of Postgres. I'm currently running Postgres v8.4.1 on Debian Linux 64-bit. I have a simple query that when planned either uses hash-aggregates or a sort depending on the amount of working memory available. The probl

[PERFORM] HashAggregate slower than sort?

2010-06-20 Thread Jatinder Sangha
Hi, I've noticed something that I find strange with the hash-aggregate feature of Postgres. I'm currently running Postgres v8.4.1 on Debian Linux 64-bit. I have a simple query that when planned either uses hash-aggregates or a sort depending on the amount of working memory available. The problem

Re: [PERFORM] HashAggregate slower than sort?

2010-06-21 Thread Jatinder Sangha
nks, --Jatinder -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: 18 June 2010 18:59 To: Jatinder Sangha; pgsql-performance@postgresql.org Subject: Re: [PERFORM] HashAggregate slower than sort? "Jatinder Sangha" wrote: > I have a simple query that w