Postgres Pro
Downloads
Home   >   mailing lists

Re: Worse performance with higher work_mem? - Mailing list pgsql-general

From Tom Lane
Subject Re: Worse performance with higher work_mem?
Date
Msg-id 12501.1579024449@sss.pgh.pa.us
Whole thread Raw
In response to Re: Worse performance with higher work_mem?  (Israel Brewster <ijbrewster@alaska.edu>)
List pgsql-general
Tree view 
Israel Brewster <ijbrewster@alaska.edu> writes:
> On Jan 13, 2020, at 3:46 PM, Rob Sargent <robjsargent@gmail.com> wrote:
>> I don’t see that you’ve updated the statistics?

> Ummmm….no. I know nothing about that :-)

Just do a manual ANALYZE on the table, if you don't want to wait
around for autovacuum to get to it.

            regards, tom lane

pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: Worse performance with higher work_mem?
Next
From: Michael Lewis
Date:
Subject: Re: Multiple Aggregations Order