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.
