| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Dror Matalon <dror(at)zapatec(dot)com>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Speeding up Aggregates |
| Date: | 2003-10-10 17:32:32 |
| Message-ID: | 200310101032.32271.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Dror,
> Ouch. I just double checked and you're right. Is this considered a bug,
> or just an implementation issue?
It's an implementation issue, which may be fixed by 7.5 but not sooner.
Basically, the free ability of PostgreSQL users to define their own
aggregates limits our ability to define query planner optimization for
aggregates. Only recently has anyone suggested a feasable way around this.
> While I've seen this hint a few times in the lists, it seems like it's
> one of those magic incantations that those in the know, know about, and
> that people new to postgres are going to be surprised by the need to use
> this idiom.
It IS in the FAQ.
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-10-10 17:34:52 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Previous Message | Bill Moran | 2003-10-10 17:26:40 | Re: One or more processor ? |