Horton

Re: Worse performance with higher work_mem?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Israel Brewster <ijbrewster@alaska.edu>
Cc: Rob Sargent <robjsargent@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2020-01-14T17:54:09Z
Lists: pgsql-general 
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