From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Memory Tuning |
Date: | 2001-03-30 14:45:34 |
Message-ID: | 20010330084534.A20437@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am looking for information on tuning memory usage for Postgres on Linux
(2.2 kernel). In particular I have a lot of memory relative to the size
of my database and am looking to reduce latency in queries.
Searching goegle turned up a few other cases of people asking about memory
tuning, but I didn't see any answers.
I have tried increasing the memory allowed for in memory sorts and the
estimate of available buffer caching. I haven't tried raising the buffer
space per connection as the documenation didn't seem to indicate
that that would help. This seems to have helped a little, but it is
hard to tell since the current delay is about 1 second and the queries
seem to happen faster when they are repeated after a short amount of
time.
For some idea of the specific problem, I am setting up a replacement
web server for my hobby server. The new box has a 1GHz Tbird with 500MB
of memory and a 20G 7200rpm IDE disk. The database is effectively static,
with rows for 300 games, 4000 people and 11000 people/game ratings and
a couple of other miscelaneous tables with a handful of rows each.
I am mostly interested in reducing the latency of requests while maintaining
the flexibility of using the database. Eventually there will be online data
entry so I don't want to switch to writing static files for the most of the
different possible reports.
From | Date | Subject | |
---|---|---|---|
Next Message | Mihai Gheorghiu | 2001-03-30 14:47:36 | What is faster? |
Previous Message | David Lizano | 2001-03-30 11:51:43 | Re: A valuable addition to PHP... |