Re: pgsql: Avoid creation of the free space map for small heap relations.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: pgsql: Avoid creation of the free space map for small heap relations.
Дата
Msg-id CAA4eK1LNj9MZOngxdK3GYcPJJvs8DLmnWbSR3o0W-xshuafrTA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Avoid creation of the free space map for small heap relations.  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: pgsql: Avoid creation of the free space map for small heap relations.  (John Naylor <john.naylor@2ndquadrant.com>)
Re: pgsql: Avoid creation of the free space map for small heap relations.  (John Naylor <john.naylor@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Jan 28, 2019 at 11:10 AM Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:
>
> >>>>> "Amit" == Amit Kapila <amit.kapila16@gmail.com> writes:
>
>  Amit> Yes, so this could be the cause of the problem. I think we need
>  Amit> to change the tests added by the patch such that they don't rely
>  Amit> on vacuum to remove dead-row versions? Do you or anybody else see
>  Amit> any better way to fix this?
>
> Do you just need to create free space on a page that didn't have enough
> before? It might be worth tweaking the fillfactor rather than trying to
> delete anything.
>

No, it also depends on vacuum to remove rows and then truncate the
relation accordingly.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: A few new options for vacuumdb
Следующее
От: Amit Langote
Дата:
Сообщение: Re: speeding up planning with partitions