Performance/Reliability statistics?
От | Jason M.Felice |
---|---|
Тема | Performance/Reliability statistics? |
Дата | |
Msg-id | 20000427152554.299FB1370C@mail.cronosys.com обсуждение исходный текст |
Ответы |
Re: Performance/Reliability statistics?
|
Список | pgsql-general |
To start this in the typical I-just-joined-this-list fasion: Hello, all: I'm pitching a project for a client currently and have narrowed the choices for the back-end down to PostgreSQL vs. InterBase vs. Oracle. InterBase and Oracle both have basic performance and reliability statistics (InterBase says it's good for about 700 users and about a 10,000 row database, for example), but I have not been able to find any such information about PostgreSQL. I know that any such information would be subjective, but I'm looking to make sure that PostgreSQL is in the same ball-park as the project. This is going to be a PHP-written web-based application with approximately 2000 users which come in two classes, the first class (which is about 1900 of the users) will usually be using the system once a day, maybe in the morning - maybe not even that regularly. The remaining 100 (well, less than that actually - maybe 50?), will be using the system constantly between 7AM and 5PM every day. The database structure is going to be medium-sophisticated but it will really revolve around two or three tables, the most central table will be indexed multiple ways and heavily read and updated simultaneously. Okay, do we have any statistics on a somewhat-similar environment? I love PostgreSQL, so I don't mean to offend anyone by saying this, but I really haven't seen it used in this scale environment... Anyone? Tricks to keep it running? (I noticed on another list that a backend horking causes the others to rollback and shutdown to avoid corrupting shared memory, so I'll be putting this into inittab ;-) Thanks in advance, -Jason M. Felice <jfelice@cronosys.com> P.S. If there are some good medium-large-ish scale projects which are fairly stable out there, the next step will be to ask how much hardware.
В списке pgsql-general по дате отправления: