Re: Compressing table images

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Brian Hurt <bhurt(at)janestcapital(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Compressing table images
Date: 2006-05-11 20:46:58
Message-ID: 4463A2C2.70807@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Brian Hurt wrote:
> My apologies if this subject has already been hashed to death, or if
> this is the wrong list, but I was wondering if people had seen this paper:
> http://www.cwi.nl/htbin/ins1/publications?request=intabstract&key=ZuHeNeBo:ICDE:06
>
>
> Basically it describes a compression algorithm for tables of a
> database. The huge advantage of doing this is that it reduced the disk
> traffic by (approximately) a factor of four- at the cost of more CPU
> utilization.
> Any thoughts or comments?

I don't know if that is the algorithm we use but PostgreSQL will
compress its data within the table.

Joshua D. Drake

>
> Brian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-05-11 20:47:06 Re: sblock state on FreeBSD 6.1
Previous Message Simon Riggs 2006-05-11 20:16:05 Re: BEGIN inside transaction should be an error