Search Postgresql Archives

Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached

Subject: Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Sat, 20 Feb 2021 16:15:55 +0100
In-reply-to: <20210220135641.GB30604@hjp.at>
References: <CAADeyWihs2wwUmyUJmEav20sXUanp8P9BpJMQVUApoBQV-HMgg@mail.gmail.com> <CAHOFxGrPSnwrw3yq9XM0k=g84r1bgNc2xyYVxW+NX9FCnSVTTA@mail.gmail.com> <CAADeyWijZ-P4Gcz30+5+E6tuB17Py6aLAtCPaPypWugaf8Tdyw@mail.gmail.com> <CAHOFxGotQte0Cjsxm-ZqS8a_yVHqCq+CFB2RXAPD3n8qNgXoEA@mail.gmail.com> <20210220135641.GB30604@hjp.at>

Thank you all, I will try at first

shared_buffers = 16GB and

index on words_scores(uid, length(word) desc)

Follow-Ups:
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Alexander Farber

References:
- Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Alexander Farber
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Michael Lewis
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Alexander Farber
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Michael Lewis
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Peter J. Holzer