[BUGS] BUG #4692: VACUUM: write to WAL gets very slow and seems redundant

2009-03-04 Thread Peter Much
The following bug has been logged online: Bug reference: 4692 Logged by: Peter Much Email address: p...@citylink.dinoex.sub.org PostgreSQL version: 8.2.7 Operating system: FreeBSD 6.3 Description:VACUUM: write to WAL gets very slow and seems redundant Details

[BUGS] WARNING: silent data corruption possible from PL/ruby 0.5.0 (after Ruby upgrade)

2009-05-06 Thread Peter Much
Dear all, since upgrading Ruby from 1.8.6.287 to 1.8.7.72, and recompiling PL/ruby 0.5.0, functions written in PL/ruby may ignore their given parameters and instead compute with undefined values, providing nonsense results. The test-suite provided with PL/ruby will show the problem. Upgrading

[BUGS] BUG #4801: Performance failure: 600 MB written to each WAL log

2009-05-08 Thread Peter Much
The following bug has been logged online: Bug reference: 4801 Logged by: Peter Much Email address: p...@citylink.dinoex.sub.org PostgreSQL version: 8.2.13 Operating system: FreeBSD 7.2 Description:Performance failure: 600 MB written to each WAL log Details: Server

Re: [BUGS] BUG #4801: Performance failure: 600 MB written to each WAL log

2009-05-08 Thread Peter Much
Dear Rafael, I agree with You. And that is actually what I have done up to now, although for a different reason: the amount of WAL logs produced by VACUUM FULL is practically unpredictable and can be much more than the database size, and since that database belongs to the backup system, the backup

Re: [BUGS] BUG #4801: Performance failure: 600 MB written to each WAL log

2009-05-08 Thread Peter Much
Dear Simon, On Fri, May 08, 2009 at 07:15:19PM +0100, Simon Riggs wrote: ! > Server becomes very slow while tremendous amounts of data are written ! > to WAL logs - disk activity log shows 600 MB of effective write ! > requests before each 16 MB WAL log is archived and recycled. ! ! VACUUM FULL

[BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Peter Much
The following bug has been logged online: Bug reference: 4932 Logged by: Peter Much Email address: p...@citylink.dinoex.sub.org PostgreSQL version: 8.4.0 Operating system: FreeBSD 7.2 Description:Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing Details: In chap

Re: [BUGS] BUG #4932: Upgrade 8.2.13 -> 8.4.0 - Kerberos option missing

2009-07-22 Thread Peter Much
Dear Magnus! On Wed, Jul 22, 2009 at 11:52:32AM +0200, Magnus Hagander wrote: ! On Wed, Jul 22, 2009 at 11:42, Peter Much wrote: ! > In chapter 19.3.5 of the manual an option "krb_server_hostname" is ! > mentioned. ! > This option was present in 8.2 but is no longer present