Skip site navigation (1) Skip section navigation (2)

Re: Feature proposal

From: Wojciech Strzałka <wstrzalka(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature proposal
Date: 2010-08-30 19:51:01
Message-ID: 824699945.20100830215101@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
No I don't, but definitely will try tomorrow

> Excerpts from wstrzalka's message of jue ago 26 03:18:36 -0400 2010:

>> So after turning off fsync & synchronous_commit (which I can afford as
>> I'm populating database from scratch)
>> I've stucked at 43 minutes for the mentioned table. There is no PK,
>> constrains, indexes, ... - nothing except for data.

> Are you truncating the table in the same transaction that copies the
> data into it?  If you do that, an optimization to skip WAL fires getting
> you a nice performance boost.  You need to have WAL archiving turned off
> though.

> Also, if you do that, perhaps there's no point in turning off fsync and
> synch_commit because an fsync will be done only once when the copy is
> complete.




-- 
Pozdrowienia,
 Wojciech Strzałka


In response to

pgsql-general by date

Next:From: Filip RembiałkowskiDate: 2010-08-30 19:55:09
Subject: Re: Restore referencial integrity
Previous:From: Vick KheraDate: 2010-08-30 19:42:24
Subject: Re: MySQL versus Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group