Re: [ADMIN] Index relation size

2004-10-25 Thread Scott Marlowe
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,

Re: [ADMIN] Index relation size

2004-10-25 Thread Gaetano Mendola
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 upgrad

[ADMIN] Index relation size

2004-10-25 Thread Rigmor Ukuhe
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 mome