Date: Mon, 25 Feb 2019 03:41:18 -0700 (MST)
From: Kim <support@mekong.be>
To: pgsql-performance@postgresql.org
Message-ID: <1551091278468-0.post@n3.nabble.com>
Subject: Query slow for new participants
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Hello,

I have an article query which returns articles enabled for a participant.
Article table =E2=80=93 Participant table =E2=80=93 Table in between which =
stores the links
between the Article and particitpant including characteristics such as
enabled.
It is possible to search on the articles by number, description,=E2=80=A6
For all of my participants, the articles are return in up to 3 seconds.
However, when I add a new participant, which has in fact very few articles
enabled, the query takes up to 30 seconds.
When running analyse explain, I can see that the execution plan for all
participants uses indexes and joins the table in the same order.
For the new participant, also indexes are used, but the tables are joined i=
n
a different order which makes the query very slow.
Is there any way how I can make the queries fast for new participants? This
is a big problem, because for new participants, speed is even more
important.

Thank you for your help.


--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f205008=
1.html