Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-08 Thread Andres Freund
Hi, On 2019-05-08 21:35:06 +0500, Andrey Borodin wrote: > > 8 мая 2019 г., в 1:16, Andres Freund написал(а): > > > > We probably can't remove the ringbuffer concept from these places, but I > > think we should allow users to disable them. Forcing bulk-loads, vacuum, > > analytics queries to go t

Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-08 Thread Andres Freund
Hi, On 2019-05-08 10:08:03 -0400, Robert Haas wrote: > On Tue, May 7, 2019 at 4:16 PM Andres Freund wrote: > > Just to attach some numbers for this. On my laptop, with a pretty fast > > disk (as in ~550MB/s read + write, limited by SATA, not the disk), I get > > these results. > > > > [ results

Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-08 Thread Andrey Borodin
> 8 мая 2019 г., в 1:16, Andres Freund написал(а): > > We probably can't remove the ringbuffer concept from these places, but I > think we should allow users to disable them. Forcing bulk-loads, vacuum, > analytics queries to go to the OS/disk, just because of a heuristic that > can't be disab

Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-08 Thread Tomas Vondra
On Wed, May 08, 2019 at 10:08:03AM -0400, Robert Haas wrote: On Tue, May 7, 2019 at 4:16 PM Andres Freund wrote: Just to attach some numbers for this. On my laptop, with a pretty fast disk (as in ~550MB/s read + write, limited by SATA, not the disk), I get these results. [ results showing rin

Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-08 Thread Robert Haas
On Tue, May 7, 2019 at 4:16 PM Andres Freund wrote: > Just to attach some numbers for this. On my laptop, with a pretty fast > disk (as in ~550MB/s read + write, limited by SATA, not the disk), I get > these results. > > [ results showing ring buffers massively hurting performance ] Links to som

Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

2019-05-07 Thread Andres Freund
Hi, On 2016-04-06 12:57:16 +0200, Andres Freund wrote: > While benchmarking on hydra > (c.f. > http://archives.postgresql.org/message-id/20160406104352.5bn3ehkcsceja65c%40alap3.anarazel.de), > which has quite slow IO, I was once more annoyed by how incredibly long > the vacuum at the the end of a