Home > mailing lists

Re: Speeding up Aggregates - Mailing list pgsql-performance

From	Josh Berkus
Subject	Re: Speeding up Aggregates
Date	October 3, 2003 21:38:30
Msg-id	200310031435.46838.josh@agliodbs.com Whole thread Raw
In response to	Re: Speeding up Aggregates (Dror Matalon <dror@zapatec.com>)
Responses	Re: Speeding up Aggregates
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: Dror Matalon
Date: 03 October 2003, 21:29:38
Subject: Re: Speeding up Aggregates

From: Rod Taylor
Date: 03 October 2003, 21:45:32
Subject: Re: Speeding up Aggregates

Re: Speeding up Aggregates - Mailing list pgsql-performance

Previous

Next