Re: question on error during COPY FROM

From: "Ilya Kazakevich" <Ilya(dot)Kazakevich(at)JetBrains(dot)com>
To: "'Jerome Wagner'" <jerome(dot)wagner(at)laposte(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: question on error during COPY FROM
Date: 2016-08-23 12:32:39
Message-ID: 030601d1fd3a$705c4240$5114c6c0$@JetBrains.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 be reused 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-08-23 13:44:54 Re: Sequential vs. random values - number of pages in B-tree
Previous Message pinker 2016-08-23 12:26:45 Re: Sequential vs. random values - number of pages in B-tree