Re: Autovacuum on Partitioned Tables

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Autovacuum on Partitioned Tables
Дата
Msg-id 0780cad9-0317-ef27-5b18-fa4f16087e7b@gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum on Partitioned Tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Autovacuum on Partitioned Tables  (Ryan Ruenroeng <rruenroeng@gmail.com>)
Список pgsql-general
On 10/31/22 23:05, Tom Lane wrote:
[snip]
> TBH, if you've got 50m rows, I'm not sure you need partitions at all.

Big rows (i.e. document storage tables with bytea or xml fields) can make 
databases explode in size even with only 50M rows.

(Yes, I know the arguments against it, but it works quite well when the 
database is in a cloud instance.  Worries about backup times, at least, are 
eliminated.)

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Autovacuum on Partitioned Tables
Следующее
От: jian he
Дата:
Сообщение: Re: Delete a table automatic?