more about pg_toast growth

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: more about pg_toast growth
Date: 2002-03-12 21:25:32
Message-ID: 1015968333.4584.14.camel@heat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have more data about unchecked growth of pg_toast tables. After
another day's worth of inserting and deleting, the table in question has
39504 tuples. The pg_toast table has 234773 tuples, and 126697 are
marked as unused. The sum(length(chunk_data)) from pg_toast is
433165242. The sum(length(resp_body)) -- the actual data in the table
-- is much bigger: 921615964. How is that possible?

In any case it is clear that the table is just growing again. The file
increased from 420MB to 730MB overnight, without a corresponding
increase in tuples.

The free space map settings in postgresql.conf are commented out.

I'd be very interested to find out how the sum of the length of the
tuples can be much larger than both the sum of lengths from the toast
table and the actual size of the file.

Regards,
Jeffrey Baker

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey W. Baker 2002-03-12 21:30:16 more about pg_toast growth
Previous Message Stephan Szabo 2002-03-12 21:14:38 Re: Tuning 7.2? Different than 7.1.3?