Skip site navigation (1) Skip section navigation (2)

Re: Significantly larger toast tables on 8.4?

From: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
To: Alex Hunsaker <badalex(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Significantly larger toast tables on 8.4?
Date: 2009-01-02 14:57:46
Message-ID: 20090102145746.GA23881@cuci.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
Alex Hunsaker wrote:
>On Thu, Jan 1, 2009 at 22:44, Alex Hunsaker <badalex(at)gmail(dot)com> wrote:
>> Looking at the patch we dont compress things > 1M anymore so I thought
>> maybe I was hitting that.   But no luck there are only 39 rows where
>> the row size > 1M...  With those 39 being about 22M each.

>Oh my... 25 * 40 = 1000M

>So I guess my question is are we going to recommend to people that
>they manually compress their data just for 8.4?

What seems to be hurting the most is the 1MB upper limit.  What is the
rationale behind that limit?
What would be the downside to require compressibility instead?
-- 
Sincerely,
           Stephen R. van den Berg.

"Always remember that you are unique.  Just like everyone else."

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-01-02 15:20:20
Subject: Re: Including kerberos realm
Previous:From: Andrew ChernowDate: 2009-01-02 14:23:15
Subject: Re: new libpq SSL connection option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group