Re: Row estimates for empty tables - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Row estimates for empty tables
Date
Msg-id 733B3ABE-ACF7-4C94-852F-719A46B4BD07@thebuild.com
Whole thread Raw
In response to Re: Row estimates for empty tables  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
> On Jul 24, 2020, at 12:14, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
> this application stores some results in tables (as guard against repeated calculations). Lot of these tables have
zeroor one row.  

Yes, that's the situation we encountered, too.  It's not very common (and even less common, I would assume, that it
resultsin a bad plan), but it did in this case. 

--
-- Christophe Pettus
   xof@thebuild.com




pgsql-general by date:

Previous
From: Ted Toth
Date:
Subject: when is RLS policy applied
Next
From: Adrian Klaver
Date:
Subject: Re: when is RLS policy applied