Message-ID: <4E3AC4CE.2000507@gmail.com>
Date: Thu, 04 Aug 2011 19:11:58 +0300
From: Vitalii Tymchyshyn <tivv00@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.18) Gecko/20110617 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: Robert Ayrapetyan <robert.ayrapetyan@comodo.com>,
	pgsql-performance@postgresql.org
Subject: Re: Performance die when COPYing to table with bigint PK
References: 
 <CAAboi9sk0EnbS23-tr86X9i7LdHTfdbTP4aa7r2q7NpWKaHWPA@mail.gmail.com>
	<4E366C9C.4040904@gmail.com>
	<CAAboi9uU+hMg8deuJ6Q2LxncE2HO2jykPW89fPVxHLsU8_tFrw@mail.gmail.com>
	<CAAboi9s9MCsmqYPR+KqtXstPUodiE5MzvEpk1-e+C0n6FwkkyQ@mail.gmail.com>
	<4E37F07D020000250003F9A7@gw.wicourts.gov>
	<CAAboi9t8i_+W=c-bWCeYsc4mwYyT7+mGQ5QymtO6MLcH96YdqA@mail.gmail.com>
	<4E3A7BAC020000250003FA6C@gw.wicourts.gov>
In-Reply-To: <4E3A7BAC020000250003FA6C@gw.wicourts.gov>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

04.08.11 18:59, Kevin Grittner написав(ла):
> Robert Ayrapetyan<robert.ayrapetyan@comodo.com>  wrote:
>> Kevin Grittner<Kevin.Grittner@wicourts.gov>  wrote:
>
>> [regarding tests which do show the problem]
>> tried same with 2 columns (bigint and int) - it didn't produced
>> such effect probably because data volume has critical effect.
>
> Based on what you're showing, this is almost certainly just a matter
> of pushing your volume of active data above the threshold of what
> your cache holds, forcing it to do disk access rather than RAM
> access for a significant portion of the reads.
>
> -Kevin
Yep. Seems so. Plus famous "you'd better insert data, then create indexes".
On my database it takes twice the time for int8 then for int4 to insert 
data.
Also it takes ~twice a time (2 hours) to add 200K of rows to 200M of 
rows than to make an index over 200M of rows (1 hour).

Best regards, Vitalii Tymchyshyn