Re: postgresql storage and performance questions - Mailing list pgsql-general

From Vivek Khera
Subject Re: postgresql storage and performance questions
Date
Msg-id AFCE607D-C302-4D7D-8B49-83A46551DF00@kcilink.com
Whole thread Raw
In response to Re: postgresql storage and performance questions  ("Josh Harrison" <joshques@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: postgresql storage and performance questions
Next
From: Tom Lane
Date:
Subject: Re: possible to create multivalued index from xpath() results in 8.3?