Yes, we are in a data warehouse like environments, where the database server is
used to hold very large volumn of read only historical data, CPU, memory, I/O
and network are all OK now except storage space, the only goal of compression
is to reduce storage consumption.
> Date: Thu, 30 Oct 2
PROTECTED]: [EMAIL
PROTECTED]: Re: [GENERAL] Are there plans to add data compression feature to
postgresql?CC: [EMAIL PROTECTED]; pgsql-general@postgresql.org
2008/10/29 小波 顾 <[EMAIL PROTECTED]>
1. Little integers of types take 8 bytes in the past now only take 4 or 2 bytes
if there are
I expect that compression will reduce the performance of certain queries.
http://www.postgresql.org/docs/8.3/interactive/storage-toast.html Out of
interested, in what context did you want compression?
Ron Mayer <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
27/10/2008 07:34
T
_
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
That's it, we have 4 CPUs, each of which has 4 cores, that is we have 16 cores
in total, but we have only 4 to 8 concurrent users, who regularly run complex
queries. That is we can't use all our CPU resources in such a situation to
speed up response time.
> To: pgsql-general@postgresql.org> Fr