unbalanced indexes -> fixed via dump/restore?

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: unbalanced indexes -> fixed via dump/restore?
Date: 2001-03-07 19:45:00
Message-ID: 20010307134500.A7500@mail.serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

from reading various posts over the past month, i glean that
indexes can become lopsided and slow if already-sorted input data
is added to the already-indexed table.

if so, is it good practice to

A)
pg_dump -c mydb > db.out.sql
and then
psql mydb < db.out.sql
periodically?

or is it better to

B) merely 'reindex' on occasion?

what are the pro's and con's of each approach?

--

and, is there a mechanical method to determine IF reindexing is
a productive venture -- i.e. benchmarking routines or
lopsided-ness detector algorithms?

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-03-07 19:50:34 Re: How robust is postgresql ?
Previous Message Roderick A. Anderson 2001-03-07 19:32:26 Update through views?