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