From: Aris Wendy <aris_postgre@telkom.net>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL performance
Date: Thu, 27 Feb 2003 14:09:44 +0700
Message-ID: <200302271409.44943.aris_postgre@telkom.net> (raw)
Dear Master
I have already installed postgreSQL-7.3.1 in debian woody kernel 2.4.18. I got
some curiousity.
1. I don't have wal_files in my postgresql.conf.
2. There is no SHMMIN,SHMSEG,SEMMNI,SEMMNS,SEMMSL,SEMMAP,SEMVMX in
/proc/sys/kernel because I want to tune up my postgreSQL server.
3. I used HP LC Netserver P133 RAM 128, and I still used postgresql.conf
(original). When update 2 tables in the same schema and I do it 30 times with
the same query. The tables have 45 fields and 19000 records. Look at the
bellow. I used vmstat command :
(at first when I turn on my PC)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 0 85724 1360 27652 0 0 13 1 104 7 1 0 99
(at firs time I used my database : psql csa)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 0 52848 1464 59396 0 0 10 4 104 5 1 0 99
(at first time I update my table)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
1 0 0 0 40772 1476 70052 0 0 10 9 104 5 2 0 98
(at 11 times)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 0 6536 456 106920 0 0 35 289 112 19 31 4 64
(at 12 times)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 132 6548 456 106924 0 0 34 303 113 19 32 5 63
(at 30 times)
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
0 0 0 972 6436 488 108080 0 0 99 385 119 26 25 5 71
In my postgresql.conf : autocommit=true (by default) .....so if there is
autcommit mode why potgreSQL still used memory and virtual memory to get
transaction.
TIA
Best Reagards
Aris Wendy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: aris_postgre@telkom.net
Subject: Re: PostgreSQL performance
In-Reply-To: <200302271409.44943.aris_postgre@telkom.net>
References: <200302271409.44943.aris_postgre@telkom.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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