Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the offset of a tuple inside a table - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Get the offset of a tuple inside a table
Date
Msg-id 4C990BB60200002500035AB2@gw.wicourts.gov
Whole thread Raw
In response to Get the offset of a tuple inside a table  (Pei He <hepeimail@gmail.com>)
Responses Re: Get the offset of a tuple inside a table  (Pei He <hepeimail@gmail.com>)
List pgsql-hackers
Tree view 
Pei He  wrote:
> The offset is the order of a tuple in a Sequential Scan.
That's not a safe assumption.  Try starting a sequential scan against
a large table on one connection; then before it finishes, start the
same query on another connection.  The second query joins the one
already in progress and then starts over, "wrapping around".
-Kevin

pgsql-hackers by date:

Previous
From: Pei He
Date:
Subject: Re: Get the offset of a tuple inside a table
Next
From: Itagaki Takahiro
Date:
Subject: Re: trailing whitespace in psql table output