čt 28. 11. 2019 v 15:51 odesílatel Laurenz Albe
napsal:
> On Wed, 2019-11-27 at 08:47 +0100, Pavel Stehule wrote:
> > The most significant issue was missing correct estimation for coalesce
> function.
> > He had to rewrite coalesce(var, X) = X to "var IS NULL or var = X".
> > Then the result was
On Wed, 2019-11-27 at 08:47 +0100, Pavel Stehule wrote:
> The most significant issue was missing correct estimation for coalesce
> function.
> He had to rewrite coalesce(var, X) = X to "var IS NULL or var = X".
> Then the result was very satisfactory.
>
> postgres=# explain analyze select * from
čt 28. 11. 2019 v 4:48 odesílatel Pavel Stehule
napsal:
> Hi
>
> čt 28. 11. 2019 v 3:56 odesílatel David Fetter napsal:
>
>> On Wed, Nov 27, 2019 at 08:47:56AM +0100, Pavel Stehule wrote:
>> > Hi
>> >
>> > I have a report from my customer about migration his application from
>> > Oracle to Postg
Hi
čt 28. 11. 2019 v 3:56 odesílatel David Fetter napsal:
> On Wed, Nov 27, 2019 at 08:47:56AM +0100, Pavel Stehule wrote:
> > Hi
> >
> > I have a report from my customer about migration his application from
> > Oracle to Postgres.
> >
> > The most significant issue was missing correct estimatio
On Wed, Nov 27, 2019 at 08:47:56AM +0100, Pavel Stehule wrote:
> Hi
>
> I have a report from my customer about migration his application from
> Oracle to Postgres.
>
> The most significant issue was missing correct estimation for coalesce
> function. He had to rewrite coalesce(var, X) = X to "var
Hi
I have a report from my customer about migration his application from
Oracle to Postgres.
The most significant issue was missing correct estimation for coalesce
function. He had to rewrite coalesce(var, X) = X to "var IS NULL or var =
X". Then the result was very satisfactory.
Example:
creat
