Re: Significantly larger toast tables on 8.4?

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Alex Hunsaker <badalex(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Significantly larger toast tables on 8.4?
Date: 2009-01-04 04:56:57
Message-ID: 49604199.1070509@rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alex Hunsaker wrote:
> For the record I just imported a production database that sits at
> about ~20G right now with *zero* size increase (rounding to the
> nearest gigabyte). That's with basically the exact same schema just
> different data.
>
>

Guessing you don't have many plain text rows > 1M.

> I don't suppose you could export some random rows and see if you see
> any size increase for your data? My gut says you wont see an
> increase.
>

Will see what I can do.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Hunsaker 2009-01-04 05:15:09 Re: Significantly larger toast tables on 8.4?
Previous Message Alex Hunsaker 2009-01-04 04:29:02 Re: Significantly larger toast tables on 8.4?