Re: Select performance vs. mssql

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Select performance vs. mssql
Дата
Msg-id 4293D500.8010908@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Select performance vs. mssql  (mark durrant <markd89@yahoo.com>)
Ответы Re: Select performance vs. mssql  ("Jim C. Nasby" <decibel@decibel.org>)
Список pgsql-performance
> --As Chris pointed out, how real-world is this test?
> His point is valid. The database we're planning will
> have a lot of rows and require a lot of summarization
> (hence my attempt at a "test"), but we shouldn't be
> pulling a million rows at a time.

If you want to do lots of aggregate analysis, I suggest you create a
sepearate summary table, and create triggers on the main table to
maintain your summaries in the other table...

> --MSSQL's ability to hit the index only and not having
> to go to the table itself results in a _big_
> performance/efficiency gain. If someone who's in
> development wants to pass this along, it would be a
> nice addition to PostgreSQL sometime in the future.
> I'd suspect that as well as making one query faster,
> it would make everything else faster/more scalable as
> the server load is so much less.

This is well-known and many databases do it.  However, due to MVCC
considerations in PostgreSQL, it's not feasible for us to implement it...

Chris

В списке pgsql-performance по дате отправления:

Предыдущее
От: John A Meinel
Дата:
Сообщение: Re: Select performance vs. mssql
Следующее
От: "SpaceBallOne"
Дата:
Сообщение: Can anyone explain this: duplicate dbs.