On Wed, Mar 31, 2010 at 12:44 PM, Chris Barnes
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 reclaime
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?
\d t8000_us_ts_size_test_2d
Table "dbprc001.t8000_us_ts_size_test_2d"
Column | Type | Modifiers
---+---
