Re: [PERFORM] Reindexdb and REINDEX

2004-10-24 Thread Tom Lane
"Rod Dutton" <[EMAIL PROTECTED]> writes: > My question is: will using the contrib/reindexdb or REINDEX sql command do > essentially the same job as dropping and re-creating the indexes. I.E. do > you get a fully compacted and balanced index? Yes. > How is concurrency handled by contrib/reindexd

[PERFORM] Reindexdb and REINDEX

2004-10-24 Thread Rod Dutton
Hi,   I have had some performance problems recently on very large tables (10s of millions of rows).  A vacuum full did make a large improvement and then dropping & re-creating the indexes also was very beneficial.  My performance problem has now been solved.   My question is: will using the