Re: index performance question

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: index performance question
Date: 2002-09-18 21:18:22
Message-ID: 20020918171822.B27778@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Sep 18, 2002 at 01:59:13PM -0700, Laurette Cisneros wrote:

> But, having read the postings, I must cast my vote for fixing at least the
> standard aggregates so that they work faster (by being smarter). I realize
> that there is a trade off for allowing the building of custom aggregates

I think that trade-off is probably bigger than you realise, given
that the customisability is a big feature. It's true that min() and
max() are pretty standard ways of doing things, so PostgreSQL is
pretty strange in this case. But hey, it's not like Postgres is the
_only_ strnage one here.

> pgsql have the capabilities that are needed it doesn't even have replication
> or the ability to query more than one database.

There _is_ replication for Postgres, and the "more than one database"
stuff will be handled nicely by schema support, I think.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Raymond Mitchell 2002-09-18 23:33:11 pg_dump'ing sequences that are part of a primary key
Previous Message Laurette Cisneros 2002-09-18 20:59:13 Re: index performance question