Re: [HACKERS] A couple of questions...

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