Re: Is it possible to work with big databases (up to 10Gb) under Postgres? - Mailing list pgsql-general

From Vivek Khera
Subject Re: Is it possible to work with big databases (up to 10Gb) under Postgres?
Date
Msg-id x766bf6ge1.fsf@onceler.kciLink.com
Whole thread Raw
In response to Re: Is it possible to work with big databases (up to 10Gb) under Postgres?  ("Jim Buttafuoco" <jim@spectrumtelecorp.com>)
List 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 by date:

Previous
From: Joseph Shraibman
Date:
Subject: ext3
Next
From: "Kurt Miller"
Date:
Subject: Re: pgsql-general-request@postgresql.org