Hello,<br /> <br /> Kevin.<br /> <br /> Thank you good guidelines.<br /> guidelines questions.<br /> <br /> Q1
postgres Version<br/><br />A1 PostgreSQL 8.3.3 on i386-portbld-freebsd7.0, compiled by GCC cc (GCC)<br />4.2.1
20070719 [FreeBSD]<br /><br /> ports Install.<br /> <br /> Q2 <br />A2 x<br /> <br /> Q3 Query<br />A3 x<br /> <br
/>Q4 Query<br />A4 x<br /> <br /> Q5 Error Message<br />A5<br /> postgres[681]: [506-1] WARNING: worker took too
longto start; cancelled Nov 12 11:15:12 kddi-nwmgr01 postgres[681]:<br />[507-1] WARNING: worker took too long to
start;cancelled<br /><br />ps -auxeww<br />---------+---------+---------+---------+---------+---------+--------<br
/>USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND<br />pgsql 682 99.0 0.1 9336 2740 ?? Rs
27Nov08343573:19.27 USER=pgsql<br /><br />Q6 PostgreSQL Programs<br />A6 php5-pdo_pgsql-5.2.12<br />
p5-DBD-Pg-2.16.0<br/> <br /> Q8 OS Version<br />A8 FreeBSD 7.0-RELEASE-p2<br /> <br /> Q9 Hardware Info<br />A9<br
/>CPU: Intel, Xeon2.4<br />RAM : 2GB<br />Storage<br /> RAID Card : LSI MegaRAID<br /> Battery Cache : YES<br
/> write-backCache : NO<br /> Software RAID : NO ( Hardware RAID)<br /> SAN : NO<br /> Disk : 7,200rpm SATA 3lot<br
/> Disk: RAID5 3slot<br /> <br />> Date: Tue, 19 Jan 2010 09:37:14 -0600<br />> From:
Kevin.Grittner@wicourts.gov<br/>> To: robertmhaas@gmail.com; azuneko@hotmail.com<br />> CC:
pgsql-bugs@postgresql.org<br/>> Subject: Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start;
cancelled...Systemdown<br />> <br />> yua **<azuneko@hotmail.com> wrote:<br />> <br />> > What
kindof information shall, I geve you<br />> <br />> There are some good guidelines here:<br />> <br />>
http://wiki.postgresql.org/wiki/SlowQueryQuestions<br/>> <br />> -Kevin<br /><br /><hr />【節約!】インターネット代、見直しませんか?
<ahref="http://clk.atdmt.com/GBL/go/187204509/direct/01/" target="_new">月額1,480円で快適ブロードバンド</a>