From: | Ericson Smith <eric(at)did-it(dot)com> |
---|---|
To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Numerous postmaster processes after upgrading to 7.2.3 |
Date: | 2002-10-21 16:11:35 |
Message-ID: | 1035216696.32021.19.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
Today we upgraded to ver 7.2.3 from 7.2.2.
I also dumped and restored the data before doing so, just in case :-)
I've noticed a few things...
1. The database server load is much higher ~ 2.00 instead of ~ 0.30
2. Many more postmasters are running ~ 20 instead of ~ 5
Some changes I made were:
1. Moved the log directories pg_xlog and pg_clog over to their own
drives (made symbolic links from there)
2. Changed the amount of shared memory from 350MB to 320MB
What would account for the new load? Queries seem to be taking much
longer. We have logs of RAM on the server 6GB and are running SCSI Raid
on the system. This is also a Dual Xeon system (2.4GHz).
Some more background...
1. The database locked up last night (each postgres process was in
Uninterruptible Sleep)
2. We had to cycle the power on the server to get it going again.
Any help/insights would be greatly appreciated.
- Ericson Smith
eric(at)did-it(dot)com
http://www.did-it.com
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2002-10-21 16:13:58 | Re: referential integrity violation |
Previous Message | marco ghidinelli | 2002-10-21 16:09:10 | cannot add "not null" to an existing table |