2 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 ... With all respect, pa
by 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.