Re: ctid ranges

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Thomas Munro <munro(at)ip9(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ctid ranges
Date: 2012-06-12 00:57:04
Message-ID: 1339462624.12042.18.camel@sussancws0025
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2012-06-12 02:32:27 Re: Run external SQL file via Perl dbh
Previous Message Keith Fiske 2012-06-12 00:51:19 Re: Extension table data