On Thu, 10 Oct 2019 at 19:17, Stephen John Smoogen wrote:
> On Thu, 10 Oct 2019 at 12:59, Kevin Fenzi wrote:
> >
> > On Thu, Oct 10, 2019 at 12:13:41PM -0400, Stephen John Smoogen wrote:
> > > why is work_mem = 157286kB versus 16MB ?
> >
> > Thats what the pgtune generator gave me. ;)
> >
> > I
On Thu, 10 Oct 2019 at 12:59, Kevin Fenzi wrote:
>
> On Thu, Oct 10, 2019 at 12:13:41PM -0400, Stephen John Smoogen wrote:
> > why is work_mem = 157286kB versus 16MB ?
>
> Thats what the pgtune generator gave me. ;)
>
> I don't think there's any reason it couldn't be 16MB...
OK sorry.. I expect
On Thu, Oct 10, 2019 at 12:13:41PM -0400, Stephen John Smoogen wrote:
> why is work_mem = 157286kB versus 16MB ?
Thats what the pgtune generator gave me. ;)
I don't think there's any reason it couldn't be 16MB...
kevin
--
>
> On Thu, 10 Oct 2019 at 12:02, wrote:
> >
> > From: Kevin Fenzi
>
why is work_mem = 157286kB versus 16MB ?
On Thu, 10 Oct 2019 at 12:02, wrote:
>
> From: Kevin Fenzi
>
> The current settings cause database dumps to drive the load way up
> and make the entire application slow, so we need to adjust.
> Using pgtune, these values might well be better.
>
>
From: Kevin Fenzi
The current settings cause database dumps to drive the load way up
and make the entire application slow, so we need to adjust.
Using pgtune, these values might well be better.
shared_buffers + effective_cache_size should = total memory.
random_page_cost should be lowered a
On Wed, Oct 09, 2019 at 06:03:48PM +0200, Aurelien Bompard wrote:
> Do you have a ansible patch here?
>
>Yes, sorry, this is it.
> diff --git a/roles/rabbit/queue/tasks/main.yml
> b/roles/rabbit/queue/tasks/main.yml
> index 7259984f6..68ced3015 100644
> ---