Re: postgresql storage and performance questions

From: Vivek Khera <khera(at)kcilink(dot)com>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql storage and performance questions
Date: 2007-11-20 19:14:22
Message-ID: AFCE607D-C302-4D7D-8B49-83A46551DF00@kcilink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-20 19:29:42 Re: possible to create multivalued index from xpath() results in 8.3?
Previous Message Brad Nicholson 2007-11-20 19:13:02 Re: postgresql storage and performance questions