-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 03/29/07 18:35, Tom Lane wrote:
> Benjamin Arai <[EMAIL PROTECTED]> writes:
>> I would prefer not to drop the index because the database is several
>> hundred gigs. I would prefer to incrementally add to the index.
>
> This may well be false economy. I don't have numbers at hand, but a
> full rebuild can be substantially faster than adding a large number
> of rows to the index incrementally. Also, you don't end up with a
> physically disordered index, so there is some ongoing performance
> benefit.
But deferring the index updates allows you to play games with the
the index input data, such as presorting it in order to take
advantage of locality of data.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGDGC5S9HxQb37XmcRAk1nAJwNb72P1ZBFxA8jv2d7eo2GOMTvYQCgukr7
QbOAq/Sd88ZHeOTOt+pAgcM=
=A1+E
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
