From: | "Nur Hidayat" <hidayat365(at)gmail(dot)com> |
---|---|
To: | "John R Pierce" <pierce(at)hogranch(dot)com>,pgsql-general(at)postgresql(dot)org |
Subject: | Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it? |
Date: | 2012-03-12 08:18:09 |
Message-ID: | 570762870-1331540275-cardhu_decombobulator_blackberry.rim.net-436290194-@b14.c1.bise3.blackberry |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, I am aware of that, but that's the fact I'm facing
Right now I'am happy enough my system runs well without eating up my drive :)
I'll investigate more later when time available :)
Cheers,
Nur Hidayat
.::.
Sent from my BlackBerry®
powered by The ESQ Way 165
-----Original Message-----
From: John R Pierce <pierce(at)hogranch(dot)com>
Sender: pgsql-general-owner(at)postgresql(dot)orgDate: Mon, 12 Mar 2012 00:39:28
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave.
How to compact it?
On 03/12/12 12:06 AM, Nur Hidayat wrote:
>
> I once have the same problem. In my case it's because most of my table
> using text datatype.
> When I change the field type to character varying (1000) database size
> reduced significantly
>
> Unfortunately, I haven't investigate more, but it looks like how
> postgres stores data
that doesn't make any sense. text and character varying storage is
exactly hte same, the only difference is the varchar has an optional
length constraint
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Nur Hidayat | 2012-03-12 08:20:04 | Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it? |
Previous Message | John R Pierce | 2012-03-12 07:39:28 | Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it? |