Re: [GENERAL] spool function in nbtree index

2007-07-24 Thread Jim Nasby
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

[GENERAL] spool function in nbtree index

2007-07-21 Thread Teju
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),

Re: [GENERAL] spool

2001-08-20 Thread Oliver Elphick
"Jova" wrote: >how do spool my results to a file. >I know there is a command spool on and off. How do I use it? In psql, use \o. There is also the command-line option -o. Check the manpage for psql for full details. -- Oliver Elphick[EMAIL PROTECTED] Isle

[GENERAL] spool

2001-08-20 Thread Jova
how do spool my results to a file. I know there is a command spool on and off. How do I use it? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html