Re: index performance question - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: index performance question
Date
Msg-id 20020918171822.B27778@mail.libertyrms.com
Whole thread Raw
In response to Re: index performance question  (Laurette Cisneros <laurette@nextbus.com>)
List 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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Laurette Cisneros
Date:
Subject: Re: index performance question
Next
From: Raymond Mitchell
Date:
Subject: pg_dump'ing sequences that are part of a primary key