Re: Select performance vs. mssql

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: Select performance vs. mssql
Дата
Msg-id 20050525002039.GA27519@mathom.us
обсуждение исходный текст
Ответ на Re: Select performance vs. mssql  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Select performance vs. mssql  (John A Meinel <john@arbash-meinel.com>)
Список pgsql-performance
On Tue, May 24, 2005 at 04:35:14PM -0700, Josh Berkus wrote:
>Pretty much.  There has been discussion about allowing index-only access to
>"frozen" tables, i.e. archive partitions.  But it all sort of hinges on
>someone implementing it and testing ....

Is there any way to expose the planner estimate? For some purposes it's
enough to just give a rough ballpark (e.g., a google-esque "results 1-10
of approximately 10000000") so a user knows whether its worth even
starting to page through.

Mike Stone

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

Предыдущее
От: PFC
Дата:
Сообщение: Re: Select performance vs. mssql
Следующее
От: John A Meinel
Дата:
Сообщение: Re: Select performance vs. mssql