Re: Database size

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: l(dot)rame(at)griensu(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Database size
Date: 2010-01-11 18:45:38
Message-ID: 4B4B71D2.5090405@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Francisco Reyes wrote:
> I say "don't believe" because I don't recall if byteA was stored in
> the table itself or was stored outside using TOAST.. so I am not sure
> about how/when space is released for it.

like all other data, that depends on the size of the data. if the
entire row (tuple) is under 4K (I think, don't quote me), it will be
stored in the table, otherwise it will be toasted and stored in the
PG_TOAST tables.... which also need vacuuming....

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2010-01-11 19:23:14 Re: Database size
Previous Message Francisco Reyes 2010-01-11 18:44:30 Re: how much left for restore?