Client-side compression
От | Rob Sargent |
---|---|
Тема | Client-side compression |
Дата | |
Msg-id | 4A413B6D.5070200@gmail.com обсуждение исходный текст |
Ответы |
Re: Client-side compression
|
Список | pgsql-sql |
Not sure if this belongs here or on the admin or performance list. Apologies if so. (And this may be a second posting as the first was from an un-registered account. Further apologies) My assumption is that any de/compression done by postgres would be server-side. We're considering minimizing bandwidth utilization by using client-side compression on a column value that will typically be multi-megabyte in size. We would use ALTER TABLE SET STORAGE EXTERNAL to prevent the server from un-necessary compression. Is this generally worthwhile? I haven't found any thread on the subject of client-side compress so any pointer more than welcome. Is there a great penalty for a query which delves into the value, given that the server will not be aware it's compressed? I assume we're pretty much on our own to prevent such actions (i.e. the app can never query against this column via sql).
В списке pgsql-sql по дате отправления: