Re: File compression in WinXP - Mailing list pgsql-general

From Ivan Voras
Subject Re: File compression in WinXP
Date
Msg-id hrkj84$km2$1@dough.gmane.org
Whole thread Raw
In response to File compression in WinXP  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
On 2.5.2010 16:48, pasman pasmański wrote:
> Hello.
> I'm install postgresql 8.4.3 on WinXPsp3.
> Because of small disk i create tablespace
> pointing to commpressed folder and move
> some tables to it.
> Compression is good: 10GB to 3-4GB
> speed acceptable (small activity,10 users)
>
> But is this safe ?

Microsoft "guarantees" your safety here, there should be no difference
in behaviour.

Of course, memory and other resource requirements are still dependent on
the uncompressed size. Your performance will probably be less than
without compression.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tracking down log segment corruption
Next
From: Dave Page
Date:
Subject: Re: postgres crashes - could not reattach to shared memory