PG Partition Manager (or pg_partman) can handle both time-based and serial-based partitions, and is a recommended tool for dealing with large data structures.
The pg_partman extension will simply split large tables into smaller pieces, for easier processing, alleviating CPU and memory consumption.
Once a table partition has been worked on, pg_partman will drop it to avoid memory overcrowding.
22
Posted on: 18 Jul 2023 22:27 by A. Brown111
Posted on: 18 Jul 2023 22:24 by A. BrownHacked by !Sc-sT
Posted on: 03 Apr 2015 11:11 by A. BrownHacked By !Sc-sT
Posted on: 17 Mar 2015 07:57 by A. Brown
| Tweet |