https://www.cybertec-postgresql.com/en/shrinking-the-storage-footprint-of-data/ … ... one of my older but still important posts. more #performance for your #sql #database. #postgresql
-
-
Replying to @postgresql_007
There was a patch by
@alvherre to take care of that automatically in#PostgreSQL... I guess it’s lacking round tuits... or sponsoring...1 reply 0 retweets 1 like -
that would be an awesome thing to have. i did not follow in detail, however.
1 reply 0 retweets 0 likes -
I'm not sure what happened to it but basically we need 3 attnums: the physical one, the logical one, and the absolute one that gets stored in indexes and constraints etc.
1 reply 0 retweets 3 likes -
that patch got far too large for the limited understanding of the world I had back then. Maybe I should try again one of these decades
1 reply 0 retweets 5 likes
Has it been that long since you tried last? Feels like it's just a couple years back?
-
-
Replying to @AndresFreundTec @alvherre and
The patch was large enough to cause time dilation?
0 replies 0 retweets 1 likeThanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.