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)
Ответы: Re: Select performance vs. mssql  (John A Meinel)
Список: pgsql-performance

Скрыть дерево обсуждения

Select performance vs. mssql  (mark durrant, )
 Re: Select performance vs. mssql  (Christopher Kings-Lynne, )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Neil Conway, )
  Re: Select performance vs. mssql  ("Harald Lau (Sector-X)", )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Bruno Wolff III, )
   Re: Select performance vs. mssql  (Alex Turner, )
   Re: Select performance vs. mssql  (Enrico Weigelt, )
    Re: Select performance vs. mssql  (Jochem van Dieten, )
  Re: Select performance vs. mssql  (Christopher Kings-Lynne, )
   Re: Select performance vs. mssql  ("Jim C. Nasby", )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Josh Berkus, )
   Re: Select performance vs. mssql  (PFC, )
   Re: Select performance vs. mssql  (Michael Stone, )
    Re: Select performance vs. mssql  (John A Meinel, )

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 по дате сообщения:

От: Bruno Wolff III
Дата:
Сообщение: Re: Can anyone explain this: duplicate dbs.
От: Philip Hallstrom
Дата:
Сообщение: Re: Need help to decide Mysql vs Postgres