Re: Select performance vs. mssql - Mailing list pgsql-performance

From Michael Stone
Subject Re: Select performance vs. mssql
Date
Msg-id 20050525002039.GA27519@mathom.us
Whole thread Raw
In response to Re: Select performance vs. mssql  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Select performance vs. mssql  (John A Meinel <john@arbash-meinel.com>)
List 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 by date:

Previous
From: PFC
Date:
Subject: Re: Select performance vs. mssql
Next
From: John A Meinel
Date:
Subject: Re: Select performance vs. mssql