Re: To keep indexes in memory, is large enough effective_cache_size enough?

2018-09-25 Thread David Rowley
On Tue, 25 Sep 2018 at 18:36, Sam R. wrote: > Regarding double buffering: I do not know how much double buffering would > slow down operations. > It could also be possible to turn off kernel page cache on our DB server, to > avoid double buffering. Although, we may still keep it in use. I think

Re: Why could different data in a table be processed with different performance?

2018-09-25 Thread Vladimir Ryabtsev
> 1) Which file system are you using? >From Linux's view it's ext4. Real vmdx file on Hyper-V is stored on NTFS, as far as I know. > 2) What is the segment layout of the LVM PVs and LVs? I am a bit lost with it. Is that what you are asking about? master: # pvs --segments PV VGFmt

Re: link to Slow_Query_Questions from wiki/Main Page

2018-09-25 Thread Alvaro Herrera
On 2018-Sep-25, Justin Pryzby wrote: > I asked few weeks ago [0] but didn't get a response on -docs so resending here > for wider review/discussion/. I support the idea of adding a link to "Performance Optimization". That's not a protected page, so you should be able to do it. > [0] > https://

Re: link to Slow_Query_Questions from wiki/Main Page

2018-09-25 Thread Justin Pryzby
I asked few weeks ago [0] but didn't get a response on -docs so resending here for wider review/discussion/. [0] https://www.postgresql.org/message-id/flat/20180908012957.GA15350%40telsasoft.com On Fri, Sep 07, 2018 at 08:29:57PM -0500, Justin Pryzby wrote: > Hi, > > I'm suggesting to link to:

Re: Why could different data in a table be processed with different performance?

2018-09-25 Thread Fabio Pardi
On 25/09/18 00:28, Vladimir Ryabtsev wrote: > > > it is not unusual to have 1GB cache or more...  and do not forget to drop > > the cache between tests + do a sync > I conducted several long runs of dd, so I am sure that this numbers are > fairly correct. However, what worries me is that I test