1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Rep Power

    Thumbs up Speaking of recreating indexes for performance reasons..

    Well I'm sure this is a rule of thumb for all of you old pros out there, but I was reading the docs on VACUUM and came across this little tidbit from the Postgres website:

    For performance, I would also recommend using the REINDEX TABLE command periodically. It appears that vacuum does not free space from indexes, only from tables. With one query we had, we saw a 50% improvement in speed after doing a REINDEX.

    Tom Burke
    Eppend, Inc.
    Old indexes probably look like swiss cheese.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    Actually, I didn't know about this one. Thanks for the tip.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo