Re: hint in determining effective_io_concurrency

2021-07-07 Thread Luca Ferrari
On Wed, Jul 7, 2021 at 11:42 PM Merlin Moncure wrote: > See thread, https://postgrespro.com/list/thread-id/2069516 > > The setting only impacts certain scan operations, it's not a gamechanger. Useful, thanks. Luca

Re: hint in determining effective_io_concurrency

2021-07-07 Thread Merlin Moncure
On Thu, Apr 22, 2021 at 2:55 PM Luca Ferrari wrote: > > On Thu, Apr 22, 2021 at 9:52 PM Bruce Momjian wrote: > > > > On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote: > > > Hi all, > > > I'm unable to find (apparently) a way to find out a possible value to > > > start with for effecti

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Bruce Momjian
On Thu, Apr 22, 2021 at 03:27:39PM -0500, Justin Pryzby wrote: > On Thu, Apr 22, 2021 at 10:22:59PM +0200, Luca Ferrari wrote: > > On Thu, Apr 22, 2021 at 10:15 PM Justin Pryzby wrote: > > > Note that the interpretation of this GUC changed in v13. > > > https://www.postgresql.org/docs/13/release-1

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Justin Pryzby
On Thu, Apr 22, 2021 at 10:22:59PM +0200, Luca Ferrari wrote: > On Thu, Apr 22, 2021 at 10:15 PM Justin Pryzby wrote: > > Note that the interpretation of this GUC changed in v13. > > https://www.postgresql.org/docs/13/release-13.html > > |Change the way non-default effective_io_concurrency values

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Luca Ferrari
On Thu, Apr 22, 2021 at 10:15 PM Justin Pryzby wrote: > Note that the interpretation of this GUC changed in v13. > https://www.postgresql.org/docs/13/release-13.html > |Change the way non-default effective_io_concurrency values affect > concurrency (Thomas Munro) > |Previously, this value was adj

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Justin Pryzby
On Thu, Apr 22, 2021 at 03:52:32PM -0400, Bruce Momjian wrote: > On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote: > > Hi all, > > I'm unable to find (apparently) a way to find out a possible value to > > start with for effective_io_concurrency. > > I suspect that benchmarking, e.g., us

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Bruce Momjian
On Thu, Apr 22, 2021 at 09:54:56PM +0200, Luca Ferrari wrote: > On Thu, Apr 22, 2021 at 9:52 PM Bruce Momjian wrote: > > > > On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote: > > > Hi all, > > > I'm unable to find (apparently) a way to find out a possible value to > > > start with for

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Luca Ferrari
On Thu, Apr 22, 2021 at 9:52 PM Bruce Momjian wrote: > > On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote: > > Hi all, > > I'm unable to find (apparently) a way to find out a possible value to > > start with for effective_io_concurrency. > > I suspect that benchmarking, e.g., using bon

Re: hint in determining effective_io_concurrency

2021-04-22 Thread Bruce Momjian
On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote: > Hi all, > I'm unable to find (apparently) a way to find out a possible value to > start with for effective_io_concurrency. > I suspect that benchmarking, e.g., using bonnie++ or sysbench and > testing with different values of concurren

hint in determining effective_io_concurrency

2021-04-22 Thread Luca Ferrari
Hi all, I'm unable to find (apparently) a way to find out a possible value to start with for effective_io_concurrency. I suspect that benchmarking, e.g., using bonnie++ or sysbench and testing with different values of concurrency could help to determine the max number of concurrent request, (tps, l