[about loadling large amounts of data] Felipe Santos wrote: > This might also help: > http://www.postgresql.org/docs/9.1/static/populate.html > > > Bulk load tables from text files in almost all RDMS are "log free" (Postgres' > COPY is one of them). > > The reason is that the database doesn't need to waste resources by writing > the log because there's no > risk of data loss. If the COPY operation fails, your data will still live in > the text files you're > trying to bulk load from.
That is only true if the table was created in the same transaction as the COPY statement. Otherwise it could be that recovery starts after CREATE TABLE but before COPY, and it would have to recover the loaded data. Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
