On 11/1/22 10:11, Ryan Ruenroeng wrote:T
Thanks all for your responses. We have a couple of tables. Each with
50-70mil rows currently, but they are expected to grow. Partitioning seems
to be a better long-term strategy, queries to these tables, using their
existing indexes, leaves them basicall
Thanks all for your responses. We have a couple of tables. Each with
50-70mil rows currently, but they are expected to grow. Partitioning seems
to be a better long-term strategy, queries to these tables, using their
existing indexes, leaves them basically unusable (lng run times).
FYI, we are
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 qui
On Mon, 2022-10-31 at 17:26 -0500, Ryan Ruenroeng wrote:
> There is a statement in the Postgres Docs: "Partitioned tables are not
> processed by autovacuum."
>
> What does the above statement mean?
> Does autovacuum not process both the parent and the child tables in a
> partition relationship?
Ron writes:
> On 10/31/22 17:26, Ryan Ruenroeng wrote:
>> I have a table with 50+ million rows that gets data added to/wiped from it
>> every 90 days. We are planning to break this table into a few thousand
>> partitions.
> 1. That's a lot of partitions. Older (like v12) query optimizers don't
On 10/31/22 17:26, Ryan Ruenroeng wrote:
Hello there!
There is a statement in the Postgres Docs: "Partitioned tables are not
processed by autovacuum."
What does the above statement mean?
Does autovacuum not process both the parent and the child tables in a
partition relationship?
Partition
Hello there!
There is a statement in the Postgres Docs: "Partitioned tables are not
processed by autovacuum."
What does the above statement mean?
Does autovacuum not process both the parent and the child tables in a
partition relationship?
What is the definition of a partitioned table?
I have a
