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 22:54:56
Message-ID: 199908152254.SAA19121@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 Martin Weinberg 1999-08-15 23:02:33 Are there any limits on index size?
Previous Message Oliver Elphick 1999-08-15 20:27:17 Re: [GENERAL] User not in pg_shadow