Numerous postmaster processes after upgrading to 7.2.3

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

Responses

Browse pgsql-general by date

  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