Re: [PERFORM] [PERFORMANCE] how to set wal_buffers

2009-08-25 Thread Jaime Casanova
On Sun, Aug 23, 2009 at 5:26 PM, Jeff Janes wrote: >>> >>> One problem is as you note.  How is the average user supposed to know >>> what is the size of the redo that is generated by a typical >>> transaction? >>> >> >> one way is if there is a way to know how many blocks have been written >> by po

Re: [PERFORM] [PERFORMANCE] how to set wal_buffers

2009-08-23 Thread Jeff Janes
On Sun, Aug 23, 2009 at 1:25 PM, Jaime Casanova wrote: > On Thu, Aug 20, 2009 at 11:38 PM, Jeff Janes wrote: >>> -- Forwarded message -- >>> From: Jaime Casanova >>> To: psql performance list >>> Date: Wed, 19 Aug 2009 19:25:11 -0500 >>> Subject: [PERFORMANCE] how to set wal_buffe

Re: [PERFORM] [PERFORMANCE] how to set wal_buffers

2009-08-23 Thread Jaime Casanova
On Thu, Aug 20, 2009 at 11:38 PM, Jeff Janes wrote: >> -- Forwarded message -- >> From: Jaime Casanova >> To: psql performance list >> Date: Wed, 19 Aug 2009 19:25:11 -0500 >> Subject: [PERFORMANCE] how to set wal_buffers >> Hi, >> >> Our fine manual says: >> """ >> The amount of