Re: Autovacuum on Partitioned Tables - Mailing list pgsql-general

From Ron
Subject Re: Autovacuum on Partitioned Tables
Date
Msg-id 0780cad9-0317-ef27-5b18-fa4f16087e7b@gmail.com
Whole thread Raw
In response to Re: Autovacuum on Partitioned Tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Autovacuum on Partitioned Tables
List 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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Autovacuum on Partitioned Tables
Next
From: jian he
Date:
Subject: Re: Delete a table automatic?