Re: [PERFORM] [repost] Help me develop new commit_delay advice

2012-10-08 Thread Peter Geoghegan
On 6 September 2012 04:20, Greg Smith wrote: > On 08/02/2012 02:02 PM, Peter Geoghegan wrote: > I dug up what I wrote when trying to provide better advice for this circa > V8.3. That never really gelled into something worth publishing at the time. > But I see some similar patterns what what you'r

Re: [PERFORM] [repost] Help me develop new commit_delay advice

2012-09-05 Thread Greg Smith
On 08/02/2012 02:02 PM, Peter Geoghegan wrote: I made what may turn out to be a useful observation during the development of the patch, which was that for both the tpc-b.sql and insert.sql pgbench-tools scripts, a commit_delay of half of my wal_sync_method's reported raw sync speed looked optimal