Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread Kevin Grittner
yua **azun...@hotmail.com wrote: PostgreSQL 8.3.3 on i386-portbld-freebsd7.0, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD] postgres[681]: [506-1] WARNING: worker took too long to start; cancelled Nov 12 11:15:12 kddi-nwmgr01 postgres[681]: [507-1] WARNING: worker took too long

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread yua ゅぁ
Subject: Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown yua **azun...@hotmail.com wrote: What kind of information shall, I geve you There are some good guidelines here: http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread Craig Ringer
On 26/01/2010 8:58 AM, yua ゅぁ wrote: RAID Card : LSI MegaRAID Battery Cache : YES write-back Cache : NO Software RAID : NO ( Hardware RAID) The LSI MegaRAID series are, AFAIK, software raid implementations. The hardware has some BIOS hooks to enable boot-loading, then the OS loads a driver

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-19 Thread yua ゅぁ
-pdo_pgsql-5.2.12 What kind of information shall, I geve you in addtion to the list above? Date: Mon, 18 Jan 2010 15:33:02 -0500 Subject: Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown From: robertmh...@gmail.com To: azun...@hotmail.com CC

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-19 Thread Kevin Grittner
yua **azun...@hotmail.com wrote: What kind of information shall, I geve you There are some good guidelines here: http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription:

[BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-18 Thread azuneko
The following bug has been logged online: Bug reference: 5284 Logged by: azuneko Email address: azun...@hotmail.com PostgreSQL version: 8.3.3 Operating system: FreeBSD7.0.2 Description:Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-18 Thread Robert Haas
On Mon, Jan 18, 2010 at 12:43 AM, azuneko azun...@hotmail.com wrote: The following bug has been logged online: Bug reference:      5284 Logged by:          azuneko Email address:      azun...@hotmail.com PostgreSQL version: 8.3.3 Operating system:   FreeBSD7.0.2 Description: