I started feeling nobody wants to answer those questions but finally got a
reply :-)
Thanks a lot Scott.
- Salma
- Original Message -
From: "Scott Marlowe"
To: "salma"
Cc: ;
Sent: Friday, December 19, 2008 5:36 AM
Subject: Re: [GENERAL] Need help - Regarding
Scott Marlowe escribió:
> On Tue, Dec 16, 2008 at 6:52 AM, salma wrote:
> > 2. What kind of compression, if any, is available in PostgreSQL.
>
> Standard unix compress I believe
No, it's our own LZ implementation, which is focused on speed but does
not compress as well as gzip or compress (see
On Tue, Dec 16, 2008 at 6:52 AM, salma wrote:
> Hi,
>
> I'd like to know:
> 1. If it is possible to compress data in the PostgreSQL.
Ayup. Anything over a standard size gets compressed out of line into
TOAST tables.
> 2. What kind of compression, if any, is available in PostgreSQL.
Standard un
Hi,
I'd like to know:
1. If it is possible to compress data in the PostgreSQL.
2. What kind of compression, if any, is available in PostgreSQL.
3. If compression is available, what kind of disk space savings can I expect
using it.
I'd appreciate it if you can take some time and get me this inf
