From: | Aris Wendy <aris_postgre(at)telkom(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | PostgreSQL performance |
Date: | 2003-02-27 07:09:44 |
Message-ID: | 200302271409.44943.aris_postgre@telkom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Rubio | 2003-02-27 07:27:54 | Re: Limiting database size ... |
Previous Message | Rajesh Kumar Mallah | 2003-02-27 06:00:47 | Re: PLSQL |