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@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
