Re: ask the database engine tuning on the server

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: ask the database engine tuning on the server
Дата
Msg-id 4DC2A121020000250003D30A@gw.wicourts.gov
обсуждение исходный текст
Ответ на ask the database engine tuning on the server  (Didik Prasetyo <prasetyodidik62@yahoo.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
Следующее
От: Brian Connolly
Дата:
Сообщение: Re: Poor query plan chosen in 9.0.3 vs 8.3.7