Questions tagged [pg-partman]
18 questions
0
votes
3 answers
Install pg_partman on macOS
Hi I have PostgreSQL 12 installed by homebrew and I clone the pg_partman at this commit https://github.com/pgpartman/pg_partman/commit/63328c5bd1f8009fc95592fcdd8ff45f148829e6.
In the cloned folder, I ran make install but it says:
(pg_partman)…
Juanito Fatas
- 9,419
- 9
- 46
- 70
0
votes
0 answers
Has anyone used temporal_tables and/or pg_partman to implement bi-temporal tables on a PostgreSQL database?
I'm trying to figure out how to implement a bi-temporal table for a product catalog on a PostgreSQL database. The catalog table could become quite big over time. I would like to achieve very good performance for frequent queries like "what is the…
MichaelP
- 121
- 2
- 6
0
votes
1 answer
Postgresql partitioned table is using space despite no entries
We have recently partitioned a master table with couple of millions of rows. This table is partitioned by "id range". There are 7 child tables created under this master table and entries are going into the child table during insert. All these are…
Karthik Murugan
- 1,429
- 3
- 17
- 28