Re: Getting all entries in a single block with ctid - Mailing list pgsql-general

From Tore Halvorsen
Subject Re: Getting all entries in a single block with ctid
Date
Msg-id CADGw-SeQZ1vcxgLhp8iPU1nC9qLqz9nA7Hi3QxVQGZD_w7M+Bw@mail.gmail.com
Whole thread Raw
In response to Re: Getting all entries in a single block with ctid  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: Getting all entries in a single block with ctid  (Tore Halvorsen <tore.halvorsen@gmail.com>)
List pgsql-general
On Mon, Jan 16, 2012 at 5:31 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
What about pgstattuple?

http://www.postgresql.org/docs/9.1/interactive/pgstattuple.html

Maybe it already does what you're trying to implement ...

Look at pageinspect module too

http://www.postgresql.org/docs/9.1/interactive/pageinspect.html

You're trying to do a quite low-level thing, so maybe this approach would
be more appropriate.

That's true, but they are more concerned with the live/deleted status of
tuples and not the logical content... Perhaps generating statements is the key for now...

--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2012 Tore Halvorsen || +052 0553034554

pgsql-general by date:

Previous
From: "P. Broennimann"
Date:
Subject: Re: Problem with pgAgent on Ubuntu
Next
From: Tore Halvorsen
Date:
Subject: Re: Getting all entries in a single block with ctid