4 ms·
"one that will eventually have to be repeated" That's the point. With pg_reorg, you can easily partition tables on a daily basis without degradation to perform
by pgbanshee 14y ago
"one that will eventually have to be repeated"
That's the point. With pg_reorg, you can easily partition tables on a daily basis without degradation to performance or sharding.
- lutusp 14y ago>> "one that will eventually have to be repeated" > That's the point. With pg_reorg, you can easily partition tables on a daily basis ... With all respect, partitioning active tables on a daily basis sounds like a very inefficient way to get around a problem with how the database is structured. It would be like pouring water into a car's radiator every day instead of fixing the problem at the source. To me, partitioning a table that logically should be a single table, and that to users appears to be a single table, needs a different solution, something less hacky, like rethinking the basic database scheme. Reasonable people may differ.