Re: Do table-level CHECK constraints affect the query optimizer?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Do table-level CHECK constraints affect the query optimizer?
Дата
Msg-id 92045cad-cede-0e90-8d22-62c847f3104e@gmail.com
обсуждение исходный текст
Ответ на Re: Do table-level CHECK constraints affect the query optimizer?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Do table-level CHECK constraints affect the query optimizer?  (Mark Dilger <mark.dilger@enterprisedb.com>)
Список pgsql-general
On 6/29/21 12:46 PM, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> writes:
>> On 6/29/21 11:42 AM, Tom Lane wrote:
>>> If there's a significant difference in relallvisible fractions, that
>>> would point to something different in your VACUUM housekeeping on
>>> the two systems.
>> Prod is brand new.  Loaded on Saturday; we saw this problem on Sunday during
>> pre-acceptance.  Thus, while running ANALYZE was top of the list of Things
>> To Do, running VACUUM was low.
>> Is that a mistaken belief?
> ANALYZE won't update relallvisible AFAIR, while VACUUM will.
> So if you are depending on lots of IOS, you need a round of
> vacuuming.

What's an IOS?

-- 
Angular momentum makes the world go 'round.



В списке pgsql-general по дате отправления:

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: Do table-level CHECK constraints affect the query optimizer?
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: Do table-level CHECK constraints affect the query optimizer?