Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group