Re: tuning question

Take a look at:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY
and
http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#SYSVIPC

I am not sure if RedHat provides different default values than what
PostgreSQL normally comes with.
I would also run some typical test queries after changing some of these
values, especially work_mem to make sure your not impacting performance
too heavily.

I'm not sure what else is running on the system, or what type of usage
you are expecting, but 2GB of ram might turn out to be enough for
PostgreSQL.

Also take a look at this:
http://www.revsys.com/writings/postgresql-performance.html

I found it to be useful, although I believe some of the suggestions the
author makes are assuming that you have a large PostgreSQL installation.
He has an interesting note about random_page_cost which might be one of
the numbers you might want to change.

Mag Gam wrote:
> 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
>
>

--
David Gardner