Skip site navigation (1) Skip section navigation (2)

tuning question

From: "Mag Gam" <magawake(at)gmail(dot)com>
To: "PostgreSQL List - Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: tuning question
Date: 2008-12-12 01:09:32
Message-ID: 1cbd6f830812111709u67198f90s5e1542ae3c7accc7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello All,

Running 8.3.4. My situation is a little unique. I am running on a 1
core with 2GB of memory on Redhat Linux 5.2. My entire installation of
pgsql is about 8GB (compressed) from pgdump.  I have 6 databases The
data is keep growing since I plan to add more field to my database and
it will increase dramatically.

My goal is I don't want to use a lot of memory! My storage is faily
fast, I can do about 250Mb/sec (sustained). I would like to leverage
my I/O instead of memory, eventhough I will suffer performance
problems. Also, is it possible to make the database data logs files
(the binary files) large? I am thinking of making them the size of 1G
each instead of very small files? My FS does better performance for
larger files...

Any ideas?

TIA

Responses

pgsql-novice by date

Next:From: Bruce HyattDate: 2008-12-12 02:31:21
Subject: Connecting via postgresql jdbc
Previous:From: Ola EkedahlDate: 2008-12-08 09:06:46
Subject: Re: Function and trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group