Re: Significantly larger toast tables on 8.4? - Mailing list pgsql-hackers

From Philip Warner
Subject Re: Significantly larger toast tables on 8.4?
Date
Msg-id 49604199.1070509@rhyme.com.au
Whole thread Raw
In response to Re: Significantly larger toast tables on 8.4?  ("Alex Hunsaker" <badalex@gmail.com>)
Responses Re: Significantly larger toast tables on 8.4?  ("Alex Hunsaker" <badalex@gmail.com>)
List 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.



pgsql-hackers by date:

Previous
From: "Alex Hunsaker"
Date:
Subject: Re: Significantly larger toast tables on 8.4?
Next
From: "Alex Hunsaker"
Date:
Subject: Re: Significantly larger toast tables on 8.4?