pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedask the database engine tuning on the server
2+ messages / 2 participants
[nested] [flat]
* ask the database engine tuning on the server
@ 2011-05-05 01:18 Didik Prasetyo <prasetyodidik62@yahoo.com>
2011-05-05 18:07 ` Re: ask the database engine tuning on the server Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 2+ messages in thread
From: Didik Prasetyo @ 2011-05-05 01:18 UTC (permalink / raw)
To: pgsql-performance
I had a problem with performance engine database, I use the server with the
following specifications
1. its storage configuration?
Storage SCSI 15K RAID 5
2. how his network?
2 gigabit bonding.
3. type / behavior of applications that connect to the db?
Direct connects one segment.
4. use the machine?
DB only
5. its os? * nix or windows?
Linux
6. how large the existing data? growth?
growth 100M / day
I had a problem with memory is always exhausted, causing
database stack or very slowly, I wanted to ask how to do the tuning
postgresql.conf settings for the above case, or whether there is another
solution
thanks for regard
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ask the database engine tuning on the server
2011-05-05 01:18 ask the database engine tuning on the server Didik Prasetyo <prasetyodidik62@yahoo.com>
@ 2011-05-05 18:07 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-05-05 18:07 UTC (permalink / raw)
To: pgsql-performance; Didik Prasetyo <prasetyodidik62@yahoo.com>
Didik Prasetyo <prasetyodidik62@yahoo.com> wrote:
> I had a problem with performance engine database, I use the server
> with the following specifications
>
> 1. its storage configuration?
> Storage SCSI 15K RAID 5
> 2. how his network?
> 2 gigabit bonding.
> 3. type / behavior of applications that connect to the db?
> Direct connects one segment.
> 4. use the machine?
> DB only
> 5. its os? * nix or windows?
> Linux
> 6. how large the existing data? growth?
> growth 100M / day
>
> I had a problem with memory is always exhausted, causing
> database stack or very slowly, I wanted to ask how to do the
> tuning postgresql.conf settings for the above case, or whether
> there is another solution
I'm not entirely sure what problem you are seeing. If you post
again, please show your version and configuration. An easy way to
do this is to run the query on this page and pastte the output into
your post:
http://wiki.postgresql.org/wiki/Server_Configuration
For general tuning advice you should read this page:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
If there is a particular query which is causing problems, please
post detail related to that query. See this page:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
If it is some other sort of problem, it helps to provide more detail
and to copy and paste any error messages:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
A couple general points which might apply:
(1) RAID 5 is OK for reads, but is slow for random writes in heavy
loads. This is mitigated somewhat by having a good RAID controller
with a battery backed RAM cache configured for write-back.
(2) You need to be running autovacuum and you need to avoid
long-running transactions (including those which show as "idle in
transaction") to avoid bloat, which can cause your database to grow
rapidly.
I hope this helps,
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-05-05 18:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-05 01:18 ask the database engine tuning on the server Didik Prasetyo <prasetyodidik62@yahoo.com>
2011-05-05 18:07 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox