Re: INSERT extremely slow with large data sets (fwd)

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: INSERT extremely slow with large data sets (fwd)
Date: 2003-11-17 14:42:43
Message-ID: 20031117144243.GE1716@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Nov 15, 2003 at 05:13:38AM -0800, George Essig wrote:
>
> VACUUM ANALYZE will reclaim disk space and update statistics used

Strictly speaking, it does not reclaim disk space. It merely marks
it as available, assuming you have enough room in your free space
map. VACUUM FULL reclaims disk space, i.e. it compacts the data
files and returns that space to the operating system.

A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joel Jacobson 2003-11-17 14:51:20 Backup/restore of pg_statistics
Previous Message Shridhar Daithankar 2003-11-17 10:43:28 Re: start of transaction