Thread: spool function in nbtree index

spool function in nbtree index

From
Teju
Date:
Hi,

 I am trying to understand the function of spool
 structure in btree index creation. I understand that
there are 2 of
 them, one for the itups to be sorted and the other
for
 dead tuples.
 Now, if I want to see all the itups that are loaded
 into the main spool (not spool for the dead tuples),
 what function should i look into and which
 structure/variable holds this value?

thanks in advance,
TPC




____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

Re: spool function in nbtree index

From
Jim Nasby
Date:
Something this detailed would best be asked on -hackers.

On Jul 21, 2007, at 7:53 PM, Teju wrote:

> Hi,
>
>  I am trying to understand the function of spool
>  structure in btree index creation. I understand that
> there are 2 of
>  them, one for the itups to be sorted and the other
> for
>  dead tuples.
>  Now, if I want to see all the itups that are loaded
>  into the main spool (not spool for the dead tuples),
>  what function should i look into and which
>  structure/variable holds this value?
>
> thanks in advance,
> TPC
>
>
>
>
> ______________________________________________________________________
> ______________
> Be a better Globetrotter. Get better travel answers from someone
> who knows. Yahoo! Answers - Check it out.
> http://answers.yahoo.com/dir/?link=list&sid=396545469
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org/
>

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)