Postgres Pro
Downloads
Home   >   mailing lists

Are there any limits on index size? - Mailing list pgsql-general

From Martin Weinberg
Subject Are there any limits on index size?
Date
Msg-id 199908152254.SAA19121@osprey.astro.umass.edu
Whole thread Raw
List pgsql-general
Tree view 
Folks,

I have a 40 million record database (about 40GB and growing) and I
notice that some of my multicolumn indices are beginning to approach
2GB on disk.

Will there be any problems spanning the 32 bit limit here (a la tables
in version 6.4)?

Thanks!

--Martin

===========================================================================

Martin Weinberg                      Phone: (413) 545-3821
Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA  01003-4525

pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [GENERAL] User not in pg_shadow
Next
From: Martin Weinberg
Date:
Subject: Are there any limits on index size?