Re: Row estimates for empty tables

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Row estimates for empty tables
Дата
Msg-id 733B3ABE-ACF7-4C94-852F-719A46B4BD07@thebuild.com
обсуждение исходный текст
Ответ на Re: Row estimates for empty tables  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ted Toth
Дата:
Сообщение: when is RLS policy applied
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: when is RLS policy applied