I doesn't realized postgresql can be such clever.

Another problem I just found is after one tuple is deleted, there will be
some slots unoccupied. The offset cannot be computed even know how much
tuples a page can contain.

I need one hash table.

Thanks
--
Pei
On Tue, Sep 21, 2010 at 8:47 PM, Kevin Grittner wrote:

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 9 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedSep 21, '10 at 9:03p
activeSep 22, '10 at 10:31a
posts9
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase