Re: index performance question

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: index performance question
Дата
Msg-id 20020918171822.B27778@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: index performance question  (Laurette Cisneros <laurette@nextbus.com>)
Список 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 по дате отправления:

Предыдущее
От: Laurette Cisneros
Дата:
Сообщение: Re: index performance question
Следующее
От: Raymond Mitchell
Дата:
Сообщение: pg_dump'ing sequences that are part of a primary key