Re: Postgres: 7.4 or 8.0?

Grant Johnson
2005-11-07T17:26:33Z

>Cool, this is the first I''ve heard of this command.  Seems to run
pretty
>quickly, too; at least, on RubyForge''s 100+ tables and 3.5M+
records it
>ran in about 3 seconds.
>
>
>
That sounds a little too quick.   You may have only reindexed your
system tables, and not your data tables.  REINDEX DATABASE redoes the
system tables, not the data tables.   If you do not use the
contrib/reindexall, you need to specify which tables to reindex.  If it
did run that fast, that is great.   It just would surprise me.