[BUGS] WAL partition ran out of space, pg_subtrans & pg_clog partially written...

2013-05-15 Thread Sean Chittenden
This is an FYI re: a bug I ran across. Background: RHEL 6 & ext4. PGDATA, a table space, and WAL logs are all on their own partitions. The WAL partition filled up (wal_keep_segments was changed, but Pg hadn't been restarted), and a write happened, and it appears to have resulted in an index pa

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Tom Lane
"Todd A. Cook" writes: > On 05/15/13 16:10, Tom Lane wrote: >> Given the reference to EvalPlanQual in your stack trace, I'm thinking >> the explanation is this 9.0 fix: > Thanks for the explanation. Is there any chance of that fix being backpatched > into 8.4? None whatsoever. Aside from the m

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Todd A. Cook
On 05/15/13 16:10, Tom Lane wrote: "Todd A. Cook" writes: On 05/15/13 13:27, tc...@blackducksoftware.com wrote: When nearly identical update queries arrive simultaneously, the first one to execute runs normally, but subsequent executions run _extremely_ slowly. We've seen this behaviour in pro

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Tom Lane
"Todd A. Cook" writes: > On 05/15/13 13:27, tc...@blackducksoftware.com wrote: >> When nearly identical update queries arrive simultaneously, the first one to >> execute runs normally, but subsequent executions run _extremely_ slowly. >> We've seen this behaviour in production, and the contrived t

Re: [BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread Todd A. Cook
On 05/15/13 13:27, tc...@blackducksoftware.com wrote: The following bug has been logged on the website: Bug reference: 8163 Logged by: Todd Cook Email address: tc...@blackducksoftware.com PostgreSQL version: 8.4.16 Operating system: Fedora 14 Description: When nearly identi

[BUGS] BUG #8163: simultaneous nearly identical update queries execute extremely slowly

2013-05-15 Thread tcook
The following bug has been logged on the website: Bug reference: 8163 Logged by: Todd Cook Email address: tc...@blackducksoftware.com PostgreSQL version: 8.4.16 Operating system: Fedora 14 Description: When nearly identical update queries arrive simultaneously, the fi

Re: [BUGS] BUG #8160: 9.3 Beta 1 Initdb doesn't work

2013-05-15 Thread Devrim GÜNDÜZ
Hi again, On Tue, 2013-05-14 at 13:48 +, bnichol...@hp.com wrote: > I've installed the 9.3 beta 1 packages (via pgdg repo and yum) and when I > try to do an initdb it fails. /var/lib/pgsql/9.3/data has nothing in it when > I attempt the initdb : > > #service postgresql-9.3 initdb > Initiali

Re: [BUGS] BUG #8159: PostgreSQlk is not working

2013-05-15 Thread Sandeep Thakkar
Please send us the installation logs. They can be found in %TEMP% with the name "install-postgresql.log" On Tue, May 14, 2013 at 5:08 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8159 > Logged by: Janos > Email address: csibe1985...@freemai