Horton
Menu

Re: postgresql storage and performance questions

Vivek Khera <khera@kcilink.com>

View thread
From: Vivek Khera <khera@kcilink.com>
To: PgSQL General ML <pgsql-general@postgresql.org>
Date: 2007-11-20T19:14:22Z
Lists: pgsql-general 
On Nov 20, 2007, at 1:04 PM, Josh Harrison wrote:

> I ran vacuum full on this table already. I haven't re-indexed it. But
> this will not affect the table size...right...since indexes are stored
> separately?
>>

Yes, but your indexes are probably bloated at this point, so to reduce  
the space they use run a reindex.