Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

: Saturday, July 02, 2016 6:28 AM To: Sfiligoi, Igor <igor.sfili...@ga.com> Cc: pgsql-general@postgresql.org Subject: Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins On Fri, Jul 1, 2016 at 7:15 PM, Sfiligoi, Igor <igor.sfili...@ga.com> wrote: > OK. Will c

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

On Fri, Jul 1, 2016 at 7:15 PM, Sfiligoi, Igor wrote: > OK. Will change our query generation code to not use the view. > (I have tried the LEFT JOIN approach, but it just does not seem to perform.) > PS: Here are the numbers for the real production query (will not provide

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

ili...@ga.com> Cc: pgsql-general@postgresql.org Subject: Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins On Fri, Jul 1, 2016 at 3:33 PM, Sfiligoi, Igor <igor.sfili...@ga.com> wrote: > No, I don't want to use LEFT JOINS. > I want to use regular joins. >

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

On Fri, Jul 1, 2016 at 3:33 PM, Sfiligoi, Igor wrote: > No, I don't want to use LEFT JOINS. > I want to use regular joins. > > But (as mentioned in my other follow-up), all the fields are not > null (was not in the original email, sorry), and are foreign > keys, so it is

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

com] Sent: Friday, July 01, 2016 1:38 PM To: Sfiligoi, Igor <igor.sfili...@ga.com>; Merlin Moncure <mmonc...@gmail.com> Cc: pgsql-general@postgresql.org Subject: Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins On 07/01/2016 01:28 PM, Sfiligoi, Igor wrote

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

PM To: Sfiligoi, Igor <igor.sfili...@ga.com> Cc: pgsql-general@postgresql.org Subject: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins On Fri, Jul 1, 2016 at 12:17 PM, Sfiligoi, Igor <igor.sfili...@ga.com> wrote: Hello. We have a view that is very generic, an

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

<igor.sfili...@ga.com> Cc: pgsql-general@postgresql.org Subject: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins On Fri, Jul 1, 2016 at 12:17 PM, Sfiligoi, Igor <igor.sfili...@ga.com> wrote: > We have a view that is very generic, and we noticed that PostgreSQL is

Re: [GENERAL] PSQL does not remove obvious useless joins

On Fri, Jul 1, 2016 at 12:17 PM, Sfiligoi, Igor wrote: > We have a view that is very generic, and we noticed that PostgreSQL is not > very good at removing useless joins, which makes our queries very slow. > > We could change our code to avoid the view and write ad-hoc

Re: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless joins

was hoping this use case would fit in. Any suggestions? Igor -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Friday, July 01, 2016 12:42 PM To: Sfiligoi, Igor <igor.sfili...@ga.com> Cc: pgsql-general@postgresql.org Subject: --EXTERNAL--Re: [GENERAL] PSQL does not

Re: [GENERAL] PSQL does not remove obvious useless joins

On Fri, Jul 1, 2016 at 12:17 PM, Sfiligoi, Igor wrote: > Hello. > > We have a view that is very generic, and we noticed that PostgreSQL is not > very good at removing useless joins, which makes our queries very slow. > > We could change our code to avoid the view and write

[GENERAL] PSQL does not remove obvious useless joins

Hello. We have a view that is very generic, and we noticed that PostgreSQL is not very good at removing useless joins, which makes our queries very slow. We could change our code to avoid the view and write ad-hoc queries to the underlying tables, but would prefer not to, if there is a way