: Saturday, July 02, 2016 6:28 AM
To: Sfiligoi, Igor
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 wrote:
> OK. Will change our query generation code to not use the view.
> (I have
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
> details):
> Original
-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 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 t
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 guaranteed to always match
com]
Sent: Friday, July 01, 2016 1:38 PM
To: Sfiligoi, Igor ; Merlin Moncure
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:
> Sorry... the example was incomplete.
>
> Al
12:42 PM
To: Sfiligoi, Igor
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 wrote:
Hello.
We have a view that is very generic, and we noticed that PostgreSQL is
not very good at rem
r
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 wrote:
> We have a view that is very generic, and we noticed that PostgreSQL is
> not very good at removing useless joins, whic
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 queries to the
> underlying
I 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
Cc: pgsql-general@postgresql.org
Subject: --EXTERNAL--Re: [GENERAL] PSQL does not remove obvious useless
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 ad-hoc queries to the
>
10 matches
Mail list logo