On 2023-10-04 23:32, Chapman Flack wrote:
> Well, for what reason does anybody run PG now with the encoding set
> to anything besides UTF-8? I don't really have my finger on that pulse.
> Could it be that it bloats common strings in their local script, and
> with enough of those to store, it could matter to use the local
> encoding that stores them more economically?
I do use CP1251 for storing some data which is coming in as XMLs in
CP1251, and thus definitely fits. In UTF-8, that data would take exactly
2x the size on disks (before compression, and pglz/lz4 won't help much
with that).
-- Ph.