On Wed, Mar 31, 2010 at 12:44 PM, Chris Barnes <compuguruchrisbarnes@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
