pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Postmasters in sleeping mode 2+ messages / 2 participants [nested] [flat]
* Postmasters in sleeping mode @ 2008-02-06 07:50 Suresh Gupta VG <suresh.g@zensar.com> 0 siblings, 1 reply; 2+ messages in thread From: Suresh Gupta VG @ 2008-02-06 07:50 UTC (permalink / raw) To: pgsql-admin Hi Team, I am on Solaris-9 and Pgsql-7.4.2. This database is running on the live production server. It takes more than 5 minutes to update one single query. This is very horrible and completely not acceptable on the live. We had scheduled Vacuum on daily basis at low traffic time of the day. Due to this, the client application is getting time out and the particular transaction is getting failed. We observed numbers of postmaster processes are running in the sleeping mode. We also observed some of the processes are running with the previous dates. The maximum connections configures is 100, but I can see number of transactions around 200 at some time of the day(May be peak time of transactions). Pls advice me to get rid of this. User Pid PPID Status Time Etime Stime Command -------- ---- ---- ------ --- ---------- -------- ----------------- pgsql 2519 1 S 1:45 30-20:50:51 Jan_06 /db1/postgresql/bin/postmaster pgsql 2522 2519 S 0:09 30-20:50:51 Jan_06 /db1/postgresql/bin/postmaster pgsql 15540 2519 S 0:00 8:26 10:31:07 /db1/postgresql/bin/postmaster pgsql 2523 2522 S 0:13 30-20:50:51 Jan_06 /db1/postgresql/bin/postmaster pgsql 15532 2519 S 0:00 9:05 10:30:29 /db1/postgresql/bin/postmaster pgsql 15233 2519 S 4:42 49:03 09:50:30 /db1/postgresql/bin/postmaster pgsql 15278 2519 S 0:36 43:17 09:56:16 /db1/postgresql/bin/postmaster pgsql 15335 2519 S 0:17 35:57 10:03:36 /db1/postgresql/bin/postmaster pgsql 15336 2519 S 0:08 35:54 10:03:39 /db1/postgresql/bin/postmaster pgsql 15330 2519 S 0:15 36:10 10:03:23 /db1/postgresql/bin/postmaster pgsql 15535 2519 S 0:00 9:05 10:30:29 /db1/postgresql/bin/postmaster pgsql 15261 2519 S 1:33 45:29 09:54:04 /db1/postgresql/bin/postmaster pgsql 15283 2519 S 0:22 42:30 09:57:03 /db1/postgresql/bin/postmaster pgsql 15539 2519 S 0:00 8:26 10:31:07 /db1/postgresql/bin/postmaster pgsql 15538 2519 S 0:00 8:26 10:31:07 /db1/postgresql/bin/postmaster pgsql 15365 2519 S 0:09 32:32 10:07:01 /db1/postgresql/bin/postmaster pgsql 15371 2519 S 0:09 31:47 10:07:46 /db1/postgresql/bin/postmaster pgsql 15534 2519 S 0:00 9:05 10:30:29 /db1/postgresql/bin/postmaster pgsql 15533 2519 S 0:00 9:05 10:30:29 /db1/postgresql/bin/postmaster pgsql 15260 2519 S 1:27 46:07 09:53:26 /db1/postgresql/bin/postmaster pgsql 15537 2519 S 0:00 8:26 10:31:07 /db1/postgresql/bin/postmaster pgsql 15235 2519 S 0:00 48:35 09:50:58 /db1/postgresql/bin/postmaster pgsql 15236 2519 S 0:00 48:35 09:50:58 /db1/postgresql/bin/postmaster pgsql 15222 2519 S 5:37 49:36 09:49:57 /db1/postgresql/bin/postmaster pgsql 15329 2519 S 0:21 36:25 10:03:08 /db1/postgresql/bin/postmaster Regards, G. V. Suresh Gupta ------------------------------------------------------------------------ --------------------------------------------------------- Innovative Technology Solutions(ITS), Zensar Technologies Zensar Knowledge Park, Plot#5, MIDC IT Tower, Kharadi, Off Nagar Road, Pune - 411014 Landline : +91-20-66453471 | +91-9890898688 Email : suresh.g@zensar.com | website: www.zensar.com DISCLAIMER: This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postmasters in sleeping mode @ 2008-02-06 09:24 Tino Schwarze <postgresql@tisc.de> parent: Suresh Gupta VG <suresh.g@zensar.com> 0 siblings, 0 replies; 2+ messages in thread From: Tino Schwarze @ 2008-02-06 09:24 UTC (permalink / raw) To: pgsql-admin On Wed, Feb 06, 2008 at 01:20:50PM +0530, Suresh Gupta VG wrote: > I am on Solaris-9 and Pgsql-7.4.2. This database is running on the live > production server. It takes more than 5 minutes to update one single > query. This is very horrible and completely not acceptable on the live. Take one of those slow queries and use "EXPLAIN ANALYZE" to figure out why they are so slow. BTW: Consider upgrading to the latest 7.4 (IIRC 7.4.11) - there should be a lot of bugfixes you are missing, some of which may lead to data corruption. > We had scheduled Vacuum on daily basis at low traffic time of the day. > Due to this, the client application is getting time out and the > particular transaction is getting failed. > > We observed numbers of postmaster processes are running in the sleeping > mode. We also observed some of the processes are running with the > previous dates. The maximum connections configures is 100, but I can see > number of transactions around 200 at some time of the day(May be peak > time of transactions). Pls advice me to get rid of this. > > User Pid PPID Status Time Etime Stime > Command > > -------- ---- ---- ------ --- ---------- -------- > ----------------- > > pgsql 2519 1 S 1:45 30-20:50:51 Jan_06 > /db1/postgresql/bin/postmaster This is just the normal state of any Unix process which currently does nothing (e.g. is waiting for input from somewhere). I'm not sure what Etime and Stime means - I don't know Solaris. The Time column tells you how much CPU time this process has used since it was created. In PostgreSQL you have one postgres process for each connection. So you can see when the connection was opened by looking at the process' creation time. HTH, Tino. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-06 09:24 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-02-06 07:50 Postmasters in sleeping mode Suresh Gupta VG <suresh.g@zensar.com> 2008-02-06 09:24 ` Tino Schwarze <postgresql@tisc.de>
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