Re: Speeding up Aggregates

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Dror Matalon <dror(at)zapatec(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Speeding up Aggregates
Date: 2003-10-03 21:35:46
Message-ID: 200310031435.46838.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dror,

> I am using 7.4, and had tried NOT EXISTS and didn't see any
> improvements.

It wouldn't if you're using 7.4, which has improved IN performance immensely.

What happens if you stop using a function and instead use a subselect?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2003-10-03 21:44:49 Re: Speeding up Aggregates
Previous Message Christopher Browne 2003-10-03 21:34:14 Re: reindex/vacuum locking/performance?