Re: [GENERAL] question on error during COPY FROM

2016-09-17 Thread Melvin Davidson
On Tue, Aug 23, 2016 at 6:04 AM, Jerome Wagner wrote: > Hello, > > in the documentation I read > https://www.postgresql.org/docs/current/static/sql-copy.html > > > COPY stops operation at the first error. This should not lead to problems > in the event of a COPY TO, but the target table will alre

Re: [GENERAL] question on error during COPY FROM

2016-08-23 Thread Francisco Olarte
On Tue, Aug 23, 2016 at 4:06 PM, Rakesh Kumar wrote: > Is it true that one datafile in PG can only belong to one object (table/index) If this is a question, yes, AFAIK ( in fact they are split in 1G chunks to prevent problems with quirky filesystems ). Search for "Each table and index is stored i

Re: [GENERAL] question on error during COPY FROM

2016-08-23 Thread Adrian Klaver
On 08/23/2016 07:06 AM, Rakesh Kumar wrote: Is it true that one datafile in PG can only belong to one object (table/index) Yes, assuming by datafile you mean an on disk file. Though one object may have many in disk files associated with it: https://www.postgresql.org/docs/9.5/static/storage-

Re: [GENERAL] question on error during COPY FROM

2016-08-23 Thread Rakesh Kumar
Is it true that one datafile in PG can only belong to one object (table/index) On Tue, Aug 23, 2016 at 9:55 AM, Francisco Olarte wrote: > On Tue, Aug 23, 2016 at 2:32 PM, Ilya Kazakevich > wrote: >>>does that mean that I should always execute a VACUUM to recover the >>>wasted space when an error

Re: [GENERAL] question on error during COPY FROM

2016-08-23 Thread Francisco Olarte
On Tue, Aug 23, 2016 at 2:32 PM, Ilya Kazakevich wrote: >>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,

Re: [GENERAL] question on error during COPY FROM

2016-08-23 Thread Ilya Kazakevich
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 r

[GENERAL] question on error during COPY FROM

2016-08-23 Thread Jerome Wagner
Hello, in the documentation I read https://www.postgresql.org/docs/current/static/sql-copy.html COPY stops operation at the first error. This should not lead to problems in the event of a COPY TO, but the target table will already have received earlier rows in a COPY FROM. These rows will not be