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 aroun
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
n any of the useless
tables, and I am not returning any columns from those tables either.
Both is known at planning time.
Or is my logic still broken?
Thanks,
Igor
-Original Message-
From: Kevin Grittner [mailto:kgri...@gmail.com]
Sent: Friday, July 01, 2016 1:29 PM
To: Sfiligoi, Igo
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
manually optimized view: 1ms
Using left joins:200s
I would have gladly paid a few ms in additional planning time!
-Original Message-
From: Kevin Grittner [mailto:kgri...@gmail.com]
Sent: Friday, July 01, 2016 1:57 PM
To: Sfiligoi, Igor
Cc: pgsql
: 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
Dear PSQL team.
I just found a weird problem.
When I pass a numeric type to a select for update statement, it locks loads of
rows, instead of a single one!
See explains below.
Is this a known bug (in 9.5)?
Any chance it was fixed in a more recent release?
Thanks,
Igor
Note: My table has abo
-ow...@postgresql.org] On Behalf Of Sfiligoi, Igor
Sent: Thursday, February 02, 2017 1:22 PM
To: pgsql-general@postgresql.org
Subject: -EXT-[GENERAL] PSQL 9.5 select for update locks too many rows when
using numeric instead of int
Dear PSQL team.
I just found a weird problem.
When I pass a numeric
