Re: [GENERAL] PostgreSQL data loads - turn off WAL

2012-09-26 Thread Jeff Janes
On Tue, Sep 25, 2012 at 9:09 AM, hartrc wrote: > My version: PostgreSQL v9.1.5 > Version string: "PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by > gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973], 64-bit" > > Basically my question is: > Is there currently any way to avoid wal gen

Re: [GENERAL] PostgreSQL data loads - turn off WAL

2012-09-26 Thread Albe Laurenz
hartrc wrote: > Basically my question is: > Is there currently any way to avoid wal generation during data load for > given tables and then have point in time recovery after that? > > Background and blurb > The situation i'm referring to here is for a development environment. I > require point in

Re: [GENERAL] PostgreSQL data loads - turn off WAL

2012-09-25 Thread Jayadevan M
Hi, > Basically my question is: > Is there currently any way to avoid wal generation during data load for given > tables and then have point in time recovery after that? Please have a look at unlogged and temporary options here - http://www.postgresql.org/docs/9.1/static/sql-createtable.html I don

[GENERAL] PostgreSQL data loads - turn off WAL

2012-09-25 Thread hartrc
My version: PostgreSQL v9.1.5 Version string: "PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973], 64-bit" Basically my question is: Is there currently any way to avoid wal generation during data load for given tables and then have poi