Re: Requirements for a database server

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: Requirements for a database server
Дата
Msg-id 20010718101004.C25319@rice.edu
обсуждение исходный текст
Ответ на Requirements for a database server  (Robert.Farrugia@go.com.mt)
Список pgsql-admin
Robert -
You mention having a PostgreSQL database in production for around a year.
May I ask what version it is? I'm guessing you're still at 6.5.X,
in which case, I'd suggest an upgrade to 7.1.2, before doing anything
more drastic.  Not only are there bug fixes, many improving stability
of the system, there are also performance enhancements, particularly in
scalability. Without knowing more details of your schema and applications
(typical queries, table sizes, etc.) we can't be of much more help.

BTW, we've had  many reports of multi-gigabyte systems performing well,
and recently a report of a multi-TERA-byte system!

There have been lots of vacuum changes, as well: Bruce and Tom have made
VACUUM much friendlier to a live system since 6.5.x.

Ross

On Wed, Jul 18, 2001 at 07:52:37AM +0200, Robert.Farrugia@go.com.mt wrote:
> Hi,
>
> I have been using postgres for the last year now.  The database has grown
> from a mere few MBs to over 100GB data and expected to top up 300GB by the
> end of the year.  Lately performance of queries, inserts, updates has
> continued to grow worse as the dataset has grown larger, even though most
> queries have indexes on them, while vacuuming the database has become a
> nightmare.  For this reason we were thinking of upgrading the system
> hardware.
>
> Is there anyone out there who has databases of this sort ?  Can he point me
> out some basic requirements for these sort of databases (processors, ram,
> storage, etc) ?  Also would it be worthwile to migrate to another database
> system which is more robust with this kind of amount of data (such as
> oracle) ?
>
> Thanks
> Robert

В списке pgsql-admin по дате отправления:

Предыдущее
От: s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Сообщение: creating large objects with pl/pgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Compile directive -8k limit