Postgres Pro
Downloads
Home   >   mailing lists

Re: question on error during COPY FROM - Mailing list pgsql-general

From Ilya Kazakevich
Subject Re: question on error during COPY FROM
Date
Msg-id 030601d1fd3a$705c4240$5114c6c0$@JetBrains.com
Whole thread Raw
In response to question on error during COPY FROM  (Jerome Wagner <jerome.wagner@laposte.net>)
Responses Re: question on error during COPY FROM  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view 
Hi.

>does that mean that I should always execute a VACUUM to recover the
>wasted space when an error is triggered or will the auto-vacuum mechanism
>do the job by itself ?


If you have autovacuum enabled it will clean up tablespace. However, space will not be returned to filesystem but will
bereused by database. 
You may run VACUUM FULL manually to return it to filesystem.

https://www.postgresql.org/docs/9.1/static/routine-vacuuming.html


Ilya Kazakevich

JetBrains
http://www.jetbrains.com
The Drive to Develop

pgsql-general by date:

Previous
From: pinker
Date:
Subject: Re: Sequential vs. random values - number of pages in B-tree
Next
From: Francisco Olarte
Date:
Subject: Re: Sequential vs. random values - number of pages in B-tree