On Tue, 23 Nov 1999, Chris Albertson wrote:
> > I am running postgresql 6.5.2 on FreeBSD. I am developing a data warehouse
> > here at Utah State University. A quick look at the docs leaves the following
> > questions:
> Yes you can do this. The answer is "RAID". I use Postgres
> mostly on Linux and some with Solaris/SPARC. On Linux I
> can make a large file system that spans several physical
> disks. Lacking an OS with built-in software RAID you could
> simply database tables and use links to point to them.
And, You can use simlinks, to place some tables on other filesystems.
> One __major__ limit with Postgres is that it uses 32 bit
> integer counters called an "OID" each row must have a
> unique OID and the OID must be unique within an intire
> Postgres installation. This means only a few billion
> rows and index entries in an entire database. I hope
> they dump this idea in a couple years or go to 64
> bit OIDs
There are an other problem with 32 bit. Some OS (linux) have trouble in
creating large files (>2G). That's not a real limit (maybe), but you may
keep a look-out for this. (I don't now, what about FreeBSD)
And the oids: if i right remember (i'm not sure), somewhere exists a
patch, (or a compile-time option?) to apply 64bit oids.
regards
--
nek;(
************
