Re: Is it possible to work with big databases (up to 10Gb) under Postgres?

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Is it possible to work with big databases (up to 10Gb) under Postgres?
Дата
Msg-id x766bf6ge1.fsf@onceler.kciLink.com
обсуждение исходный текст
Ответ на Re: Is it possible to work with big databases (up to 10Gb) under Postgres?  ("Jim Buttafuoco" <jim@spectrumtelecorp.com>)
Список pgsql-general
>>>>> "JB" == Jim Buttafuoco <jim@spectrumtelecorp.com> writes:

JB> from Oracle.  An application transaction hit between 10 to  20 tables.
JB> Most transactions execute under 1 second.

JB> The systems are Intel P3 500's running RedHat 6.2 with 600G of disk
JB> space and 512M of Ram.

What kind of performance tuning did you do?  Most interesting to me
would be your SHM and SEM kernel settings, and your postgres tuning
parameters (max connections, max memory, etc.)

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: ext3
Следующее
От: "Kurt Miller"
Дата:
Сообщение: Re: pgsql-general-request@postgresql.org