New answers tagged

0

I think that it is a bad idea to store m-to-n relationships between two tables in some kind of array or bitmap. To see why, try to come up with an efficient query to find all segments for a customer. It gets worse if you want to perform bigger joins. I think that the way to success is to reduce the data churn: why remove and re-insert everything rather than ...


1

I'm not sure, if PostgreSQL each time of this update will overwrite full file or only one bit in the hard disk? PostgreSQL will definitely rewrite the whole column on any change, as it cannot do in-place updates, let alone in-place intra-column updates. But you could break down the segment into fixed-sized sub-segments or partitions. For instance with ...


Top 50 recent answers are included