On 07/21/2012 02:05 AM, Ilya Ivanov wrote:
I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds
Zabbix database. The database on disk takes 10Gb. SQL dump takes only
2Gb. I've gone through
http://archives.postgresql.org/pgsql-general/2008-08/msg00316.php and
got some hints. Natur
Ilya Ivanov writes:
> well, it'd be good to have a link to the resource that says about 5x ratio,
> but in general I'm satisfied with that explanation. Thank you.
[ digs around ... ] It's at the bottom of this page:
http://www.postgresql.org/docs/9.1/static/install-requirements.html
which I wil
well, it'd be good to have a link to the resource that says about 5x ratio,
but in general I'm satisfied with that explanation. Thank you.
On Fri, Jul 20, 2012 at 11:23 AM, Tom Lane wrote:
> Lonni J Friedman writes:
>> On Fri, Jul 20, 2012 at 11:05 AM, Ilya Ivanov wrote:
>>> I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix
>>> database. The database on disk takes 10Gb. SQL dump takes only 2Gb.
>
>> Its not
Lonni J Friedman writes:
> On Fri, Jul 20, 2012 at 11:05 AM, Ilya Ivanov wrote:
>> I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix
>> database. The database on disk takes 10Gb. SQL dump takes only 2Gb.
> Its not entirely clear what behavior you expect here. Assuming th
On Fri, Jul 20, 2012 at 11:05 AM, Ilya Ivanov wrote:
> I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix
> database. The database on disk takes 10Gb. SQL dump takes only 2Gb. I've
> gone through
> http://archives.postgresql.org/pgsql-general/2008-08/msg00316.php and got
> s
I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix
database. The database on disk takes 10Gb. SQL dump takes only 2Gb. I've
gone through
http://archives.postgresql.org/pgsql-general/2008-08/msg00316.php and got
some hints. Naturally, the biggest table is history (the second b
