From: Vitalii Tymchyshyn <tivv00@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Robert Ayrapetyan <robert.ayrapetyan@comodo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance die when COPYing to table with bigint PK
Date: Thu, 04 Aug 2011 19:11:58 +0300
Message-ID: <4E3AC4CE.2000507@gmail.com> (raw)
In-Reply-To: <4E3A7BAC020000250003FA6C@gw.wicourts.gov>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tivv00@gmail.com, Kevin.Grittner@wicourts.gov, robert.ayrapetyan@comodo.com
Subject: Re: Performance die when COPYing to table with bigint PK
In-Reply-To: <4E3AC4CE.2000507@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox