Re: Autovacuum on Partitioned Tables

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Autovacuum on Partitioned Tables
Date: 2022-11-01 07:54:26
Message-ID: 0780cad9-0317-ef27-5b18-fa4f16087e7b@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vasily Kulikov 2022-11-01 08:09:44 Re: PQconsumeinput() may close the fd
Previous Message Laurenz Albe 2022-11-01 06:51:27 Re: Autovacuum on Partitioned Tables