pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Index relation size
3+ messages / 3 participants
[nested] [flat]

* Index relation size
@ 2004-10-25 11:02 Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
  2004-10-25 17:50 ` Re: Index relation size Gaetano Mendola <mendola@bigfoot.com>
  2004-10-26 00:44 ` Re: Index relation size Scott Marlowe <smarlowe@qwest.net>
  0 siblings, 2 replies; 3+ messages in thread

From: Rigmor Ukuhe @ 2004-10-25 11:02 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I have table with size ~35 MB, it has several indexes and couple of them are
well over 500 MB in size (they are indexes with 3-4 columns involved, with
datatypes like varchar, int4 , timestamp, boolean).
Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest
version at the moment). Are these
index sizes indicating some problems with our Postgres server?

Rigmor Ukuhe
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 19.10.2004




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Index relation size
  2004-10-25 11:02 Index relation size Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
@ 2004-10-25 17:50 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Gaetano Mendola @ 2004-10-25 17:50 UTC (permalink / raw)
  To: Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>

Rigmor Ukuhe wrote:
 > Hi,
 >
 > I have table with size ~35 MB, it has several indexes and couple of them are
 > well over 500 MB in size (they are indexes with 3-4 columns involved, with
 > datatypes like varchar, int4 , timestamp, boolean).
 > Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest
 > version at the moment). Are these
 > index sizes indicating some problems with our Postgres server?

If you do not vacuum full, this is normal.
Using a version > 7.4 then a normal vacuum "shall" be enough.


Regards
Gaetano Mendola






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Index relation size
  2004-10-25 11:02 Index relation size Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
@ 2004-10-26 00:44 ` Scott Marlowe <smarlowe@qwest.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2004-10-26 00:44 UTC (permalink / raw)
  To: Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>; +Cc: pgsql-admin

On Mon, 2004-10-25 at 05:02, Rigmor Ukuhe wrote:
> Hi,
> 
> I have table with size ~35 MB, it has several indexes and couple of them are
> well over 500 MB in size (they are indexes with 3-4 columns involved, with
> datatypes like varchar, int4 , timestamp, boolean).
> Database is VACUUMed nightly, version is 7.2.4 (cant upgrade to newest
> version at the moment). Are these
> index sizes indicating some problems with our Postgres server?

Assuming you aren't suffering from index bloat, which was a problem in
7.2, this may be normal.  To see if you are, try "reindex indexname" and
see if the index shrinks.

Multicolumn indexes being bigger than their table because of the way
they're put together, so it's likely that when you get done reindexing
the index will still be bigger than the table.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-10-26 00:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-25 11:02 Index relation size Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
2004-10-25 17:50 ` Gaetano Mendola <mendola@bigfoot.com>
2004-10-26 00:44 ` Scott Marlowe <smarlowe@qwest.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox