Re: Performance/Reliability statistics? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Performance/Reliability statistics?
Date
Msg-id Pine.LNX.4.21.0005011748411.389-100000@localhost.localdomain
Whole thread Raw
In response to Performance/Reliability statistics?  ("Jason M.Felice" <jasonf@cronosys.com>)
List pgsql-general
Jason M.Felice writes:

> InterBase and Oracle both have basic performance and reliability
> statistics

Do you mean *statistics* or `claims'?

> (InterBase says it's good for about 700 users and about a 10,000 row
> database, for example)

There are PostgreSQL databases with millions of rows and many gigabytes in
size. I couldn't tell you much about the user aspect but I don't see a
problem with 50 concurrent connections plus an extended set of occasional
users.

> (I noticed on another list that a backend horking causes the others to
> rollback and shutdown to avoid corrupting shared memory,

It will shutdown all connections and reinitialize itself. That's different
from shutting down the whole server.

> so I'll be putting this into inittab ;-)

I'd strongly advise against that. It won't solve the problem you think it
would (because there is none) and it comes with its own set of issues.

> P.S. If there are some good medium-large-ish scale projects which are
> fairly stable out there,

I don't really know what you mean with this comment but let me assure
you: people actually use this software for real work.

> the next step will be to ask how much hardware.

You can read endless threads about "hardware" in the archives. What it
comes down to is lots of memory, a good disk, a good file system, lots of
CPU power (and perhaps a second CPU); approximately in that order I'd say.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: referencial integrity constraint bug in version 7.0 beta 5
Next
From: Kevin Heflin
Date:
Subject: multiple queries using PHP