Re: ctid ranges - Mailing list pgsql-general

From Jeff Davis
Subject Re: ctid ranges
Date
Msg-id 1339462624.12042.18.camel@sussancws0025
Whole thread Raw
In response to ctid ranges  (Thomas Munro <munro@ip9.org>)
Responses Re: ctid ranges  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Fri, 2012-06-08 at 22:27 +0100, Thomas Munro wrote:
> This is slow, handled with a seq scan (as are various rephrasing with
> <, <=, etc):
>
> SELECT ... FROM ... WHERE ctid BETWEEN ... AND ...;
>
> Is there a way to retrieve the rows in a physical range quickly?

Interesting idea. However, as far as I know, there is no such support.

Regards,
    Jeff Davis




pgsql-general by date:

Previous
From: Keith Fiske
Date:
Subject: Re: Extension table data
Next
From: Toby Corkindale
Date:
Subject: Re: Run external SQL file via Perl dbh