Re: [HACKERS] effects of posix_fadvise on WAL logs

2009-05-26 Thread Greg Smith
On Tue, 26 May 2009, Mark Wong wrote: Maybe there isn't enough activity to the WAL relative to the rest of the database to show anything interesting? Maybe you could reduce checkpoint_segments and focus on UPDATEs? That's how I've been able to generate the most WAL activity relative to datab

[HACKERS] effects of posix_fadvise on WAL logs

2009-05-26 Thread Mark Wong
Hi all, Does anyone have any tests that showcase benefits from the posix_fadvise changes in xlog.c? I tried running some tests with dbt2 to see if any performance changes could be seen with 8.4beta2. I thought an OLTP type test with a lot of inserts and updates would be a good test. Unfortunate