From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | nbastin(at)rbbsystems(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] A couple of questions... |
Date: | 1998-11-02 20:47:43 |
Message-ID: | Pine.LNX.3.96.981102204652.814k-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2 Nov 1998, Thomas G. Lockhart wrote:
> > 1) How much data can postgres handle? If I'm restricted by maximum
> > file size in the OS, can I segment the data file, and if so, how many times?
>
> I vaguely recall that Postgres has support for segmented files, but that
> it has not been reported to have been tested recently. You probably
> can't count on it working, but try testing and see.
I did start to test this about 2 weeks ago, but I hit problems way before
I got to that point. I'm in the middle of running the test again at the
moment.
> > 2) Can I store the indexes for the database on a separate drive from
> > the data itself? This is useful so that I can place the indexes on a
> > solid state disk for fast searching, and leave the data on traditional
> > medium.
>
> Officially, no. If you have a fairly static database, you can create the
> index, and then move it to another disk and create a soft link to it.
> The Postgres server doesn't know about this directly, but can probably
> be fooled.
>
> > 3) Is there a maximum number of records per table? i.e., if I can
> > segment the data file, can I still only have 2 gigs of data per table?
>
> Don't know. Sorry.
>
> - Tom
>
--
Peter T Mount peter(at)retep(dot)org(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1998-11-02 21:48:18 | Re: [HACKERS] A small problem with the new inet and cidr types |
Previous Message | Constantin Teodorescu | 1998-11-02 20:07:23 | Latest PgAccess 0.91 for PostgreSQL 6.4 has been released |