| 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: | Whole Thread | Raw Message | 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? |