On Mon, Jun 11, 2012 at 7:57 PM, Jeff Davis <pgsql@xxxxxxxxxxx> wrote: > 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. yeah -- and I think it's a great thing to want to be able to do. it could be used in parallelizing tricks for example: divide up a table into N approximately equal parts and hand each one off to a work thread. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
