On Wed, Mar 31, 2010 at 12:44 PM, Chris Barnes
<compuguruchrisbarnes@hotmail.com> wrote:
> I have deleted the rows in a table and vacuumed full, there appears to be
> space allocated that after a truncate it removes.
>
> Why is this?
It's how PostgreSQL is designed. It recycles the space at a later
time, after vacuum has reclaimed the empty space and it puts new data
from inserts and updates into the now free space. More efficient then
allocating and de-allocating all the time, and lowers fragmentation.