Are there any limits on index size?

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Are there any limits on index size?
Date: 1999-08-15 23:02:33
Message-ID: 199908152302.TAA19190@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Browse pgsql-general by date

  From Date Subject
Next Message CN Liu 1999-08-16 03:47:11 [Fwd: Maximum filesize of one file]
Previous Message Martin Weinberg 1999-08-15 22:54:56 Are there any limits on index size?