-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
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
: 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
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
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
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
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
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
