Hey,
Is there a suggested number of child tables for table partitioning, I ran a
stress test on a master
table (with 800 thousand rows), trying to create 500,000 child tables for it,
each child table has 2
indexes and 3 constraints (Primary key and foreign key). I wrote a script to do
it: aft
Hey,
I'm a new user of PostgreSQL. I found one of my tables is taking unexpectedly
large space:
select pg_size_pretty(pg_relation_size('archive_files'));
pg_size_pretty
1113 MB
The structure of this table is like:
Column | Type| Modifiers
+-
