Re: Database size - Mailing list pgsql-general

From John R Pierce
Subject Re: Database size
Date
Msg-id 4B4B71D2.5090405@hogranch.com
Whole thread Raw
In response to Re: Database size  (Francisco Reyes <lists@stringsutils.com>)
List 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....



pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Database size
Next
From: Steve Crawford
Date:
Subject: Re: Database size