Thread: Large Database & Indexes (Indices?)

I am constructing a large ( by some standards) database where the largest table
threatens to be about 6-10 Gb on a Linux system. I understand that postgresql
splits the tables into manageable chunks & I have no problem with that as a
workround for the 2 GB fs limit
..     My question concerns the indexes ,the first of which looks to be  around
40 % of the table size. How is this
handled and how do I create subsequent indices on large tables given that I
can't interrupt the process,  move and symbolically link chunks ?

On Tue, 8 Feb 2000, Brian Piatkus wrote:

> I am constructing a large ( by some standards) database where the largest table
> threatens to be about 6-10 Gb on a Linux system. I understand that postgresql
> splits the tables into manageable chunks & I have no problem with that as a
> workround for the 2 GB fs limit
> ..     My question concerns the indexes ,the first of which looks to be  around
> 40 % of the table size. How is this
> handled and how do I create subsequent indices on large tables given that I
> can't interrupt the process,  move and symbolically link chunks ?

IIRC Indices you the same storage manager as tables, so they should split
at the same intervals as tables (default is 1Gb). Someone correct me if
I'm wrong.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf

Forget my last posting - sorry - I'm being stupid .fs size is, of course 4 Tb