Re: pb with join plan

2023-06-27 Thread Marc Millas
On Tue, Jun 27, 2023 at 8:12 PM Kirk Wolak wrote: > On Wed, Jun 21, 2023 at 12:10 PM Marc Millas > wrote: > >> Marc MILLAS >> On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra < >> tomas.von...@enterprisedb.com> wrote: >> >>> On 6/21/23 00:26, Marc Millas wrote: >>> > >>> > >>> > On Tue, Jun 20, 202

Re: pb with join plan

2023-06-27 Thread Kirk Wolak
On Wed, Jun 21, 2023 at 12:10 PM Marc Millas wrote: > Marc MILLAS > On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra < > tomas.von...@enterprisedb.com> wrote: > >> On 6/21/23 00:26, Marc Millas wrote: >> > >> > >> > On Tue, Jun 20, 2023 at 11:19 PM David Rowley > > > wro

Re: pb with join plan

2023-06-21 Thread Marc Millas
Marc MILLAS On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra wrote: > On 6/21/23 00:26, Marc Millas wrote: > > > > > > On Tue, Jun 20, 2023 at 11:19 PM David Rowley > > wrote: > > > > On Wed, 21 Jun 2023 at 08:34, Marc Millas >

Re: pb with join plan

2023-06-21 Thread Marc Millas
On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra wrote: > On 6/21/23 00:26, Marc Millas wrote: > > > > > > On Tue, Jun 20, 2023 at 11:19 PM David Rowley > > wrote: > > > > On Wed, 21 Jun 2023 at 08:34, Marc Millas > > wrote: > >

Re: pb with join plan

2023-06-21 Thread Tomas Vondra
On 6/21/23 00:26, Marc Millas wrote: > > > On Tue, Jun 20, 2023 at 11:19 PM David Rowley > wrote: > > On Wed, 21 Jun 2023 at 08:34, Marc Millas > wrote: > > > > On Tue, Jun 20, 2023 at 10:14 PM David Rowley > mailt

Re: pb with join plan

2023-06-20 Thread David Rowley
On Wed, 21 Jun 2023 at 10:26, Marc Millas wrote: > link to the plan with both clauses ORed (the one not finishing) > https://explain.depesz.com/s/jHO2 I'd go with the UNION or UNION ALL idea I mentioned earlier. David

Re: pb with join plan

2023-06-20 Thread Marc Millas
On Tue, Jun 20, 2023 at 11:19 PM David Rowley wrote: > On Wed, 21 Jun 2023 at 08:34, Marc Millas wrote: > > > > On Tue, Jun 20, 2023 at 10:14 PM David Rowley > wrote: > >> > >> On Wed, 21 Jun 2023 at 07:42, Marc Millas > wrote: > >> > But if I do the same with clause one OR clause 2, I have to

Re: pb with join plan

2023-06-20 Thread David Rowley
On Wed, 21 Jun 2023 at 08:34, Marc Millas wrote: > > On Tue, Jun 20, 2023 at 10:14 PM David Rowley wrote: >> >> On Wed, 21 Jun 2023 at 07:42, Marc Millas wrote: >> > But if I do the same with clause one OR clause 2, I have to kill the >> > request after an hour, seeing the filesystem showing m

Re: pb with join plan

2023-06-20 Thread Marc Millas
On Tue, Jun 20, 2023 at 10:14 PM David Rowley wrote: > On Wed, 21 Jun 2023 at 07:42, Marc Millas wrote: > > But if I do the same with clause one OR clause 2, I have to kill the > request after an hour, seeing the filesystem showing more than 140 Mb of > increased usage. > > > So, before providi

Re: pb with join plan

2023-06-20 Thread David Rowley
On Wed, 21 Jun 2023 at 07:42, Marc Millas wrote: > But if I do the same with clause one OR clause 2, I have to kill the request > after an hour, seeing the filesystem showing more than 140 Mb of increased > usage. > So, before providing the 3 explain plans (I must anonymize everything, so > s

pb with join plan

2023-06-20 Thread Marc Millas
Hi, I have a postgres 14 on linux with a 15 TB db, with 20 cores and 150GB RAM, all nvme ssd. . Currently one user :-) A join between 2 big tables and then another join with a smaller third one takes less than 1 minute and provides a result of 15 M lines. Fine. if I do add a third join, with a