From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: Steven M. Wheeler <swheeler@sabre.com>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Questions about vacuum analyze
Date: Mon, 11 Oct 1999 14:45:18 -0400
Message-ID: <8559.939667518@sss.pgh.pa.us> (raw)
In-Reply-To: <199910111614.MAA03460@candle.pha.pa.us>
Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Wonder how our create index does it. Seems it is must be similar.
CREATE INDEX (for btrees) is very similar, and really ought to share
code. Someone apparently didn't want to figure out how to generalize
psort.c to handle index tuples, though. The CREATE INDEX code is a
little better for large amounts of data but a lot worse for small
amounts --- AFAICT it doesn't take any shortcuts, even when everything
fits in memory. (I'm sure you've noticed that CREATE INDEX hits the
disk pretty hard even when the source table is empty :-(.)
I'm planning to merge the two sets of code and keep the best features of
both. I already have some first-draft code that allows them to work
with >2gig data sets.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, maillist@candle.pha.pa.us, swheeler@sabre.com, pgsql-sql@hub.org
Subject: Re: [SQL] Questions about vacuum analyze
In-Reply-To: <8559.939667518@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox