Re: [ADMIN] Looking for experience from the science community

Hi Edward

On Tue, 15 Sep 1998, Edward Maros wrote:

> I looking at PostgreSQL for a large scientific database. The information
> is primarily read only. The instrument provides the data.
>
> What is the maximum size of a Database?

The size of you hard drive(s), other wise, no limit as I understand it.
Now keep in mind that by default, the maximun size of *A* (1) record is
8K, not counting blob fields.  This can be changed at compile time, but is
the default.

> How many insertions of 10k can be put through a second?

That really depends on *HOW* you 'insert' them, if you mean to do an SQL
insert command for each record? that would be very slow.
But, if you mean 'copy' the data in from either a file or from standard
in, then that is fairly fast, exactly how fast I'm not sure.
This also depends on how many indexes you have, updating them slows things
down.  For larg mass insertions it may often be faster to drop the
indexes, copy in the data, then recreate the indexes.
OH, ya, done forget to run 'vacuum' once and a while.

Hope that helps, have a great night (or day)
Terry Mackintosh <terry@terrym.com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!