Re: Increasing work_mem slows down query, why?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Silvio Moioli <moio(at)suse(dot)de>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Increasing work_mem slows down query, why?
Date: 2020-03-30 13:40:11
Message-ID: CAFj8pRAS6jM9AfHu7R_Rg4VGOPbZRmS1VJxcWG+Y69u_cLXReQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> Is that an unreasonable value? For the sake of this discussison, I am
> targeting fairly average bare-metal SSD-backed servers with recent CPUs
> (let's say 3 year old maximum), with ample available RAM.
>

if you have SSD, then you can decrease RANDOM_PAGE_COST to 2 maybe 1.5. But
probably there will not be impact to this query.

> Thanks!
>
> Regards,
> --
> Silvio Moioli
> SUSE Manager Development Team
>
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2020-03-30 16:02:01 Re: Increasing work_mem slows down query, why?
Previous Message Pavel Stehule 2020-03-30 13:33:32 Re: Increasing work_mem slows down query, why?