Re: [GENERAL] Large database

> > 2. Is it possible for database tables to span files on more than one disk
> > partition? I'm aware that it splits files into 2GB chunks
> > automatically, but is it possible for these files to reside on more
> > than one partition?
>
> Easiest way to do this would be to put all your drives in a RAID.. Either
> just striping or RAID 5 if you need the redundancy(probably).

oddly enough, we had 2GB chunks with 6.4, but now with 6.5.1 (on FreeBSD)
we are seeing 1GB chunks:

-rw------- 1 pgsql wheel 1073741824 Aug 15 08:23 gt
-rw------- 1 pgsql wheel 1073741824 Aug 15 08:29 gt.1
-rw------- 1 pgsql wheel 626548736 Aug 17 12:29 gt.2
-rw------- 1 pgsql wheel 302964736 Aug 17 12:24 gt_callid_key
(we've had as much as gt.7)

doesn't seem to have broken anything.

it would be nice if vacuum could figure out if an extent is no longer
in use, and delete it.

currently, we need to dump the table, then nuke it and restore it.

> > 3. What's the biggest known database currently running on Postgresql?
>
> No clue.. The biggest one I'm running right now is about 5GB which isn't
> all that much.. I'm sure there are much bigger ones out there..

my table varies in size from 1 - 7 gig.
it has millions of records with a single index.

works for the most part, the problems we have are usually related to the
hardware crashing, and since we run postgres without the sync flag, well,
things can get corrupted.

--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]