Search Postgresql Archives

Re: Row estimates for empty tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Jul 24, 2020, at 12:14, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
> 
> this application stores some results in tables (as guard against repeated calculations). Lot of these tables have zero or one row. 

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

--
-- Christophe Pettus
   xof@xxxxxxxxxxxx







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux