Hi
the live one is 113G
the restored one is 78G
>
Good news for you is that you know that you can do something ;)
:)
Will this help with performance ?
Now, is the bloat in the tables (which tables ?) or in the indexes
(which indexes ?), or in the toast tables perhaps, or in the system
catalogs or all of the above ? Or perhaps there is a long-forgotten
process that got zombified while holding a huge temp table ? (not very
likely, but who knows).
Use pg_relation_size() and its friends to get an idea of the size of
stuff.
I'll look into that, thanks
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED]
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
