Without getting into too many details, why not send toast data to
non-local clients? Seems that would be the big win. The data is
already compressed, so the server wouldn't pay cpu time to recompress
anything. And since toast data is relatively large anyway, it's the
stuff you'd want to compress before putting it on the wire anyway.
If this is remotely possible let me know, I might be interested in
taking a look at it.
-Kyle
Bruce Momjian wrote:
>
> I am not excited about per-db/user compression because of the added
> complexity of setting it up, and even set up, I can see cases where some
> queries would want it, and others not. I can see using GUC to control
> this. If you enable it and the client doesn't support it, it is a
> no-op. We have per-db and per-user settings, so GUC would allow such
> control if you wish.
>
> Ideally, it would be a tri-valued parameter, that is ON, OFF, or AUTO,
> meaning it would determine if there was value in the compression and do
> it only when it would help.