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!
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? |