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

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is it possible to work with big databases (up to 10Gb) under Postgres?
Date: 2001-08-22 19:31:18
Message-ID: x766bf6ge1.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "JB" == Jim Buttafuoco <jim(at)spectrumtelecorp(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2001-08-22 20:02:37 Re: timestamp + 1 hour????
Previous Message Kurt Miller 2001-08-22 19:08:49 Re: pgsql-general-request@postgresql.org