Re: Performance die when COPYing to table with bigint PK

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Ayrapetyan" <robert(dot)ayrapetyan(at)comodo(dot)com>, "Vitalii Tymchyshyn" <tivv00(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance die when COPYing to table with bigint PK
Date: 2011-08-04 17:22:31
Message-ID: 4E3A8F07020000250003FA72@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Ayrapetyan <robert(dot)ayrapetyan(at)comodo(dot)com> wrote:

> If you look at the rest of my mail - you would notice 50 times
> difference in performance.
> What you would say?

That accessing a page from RAM is more than 50 times as fast as a
random access of that page from disk.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2011-08-04 17:40:07 Re: Need to tune for Heavy Write
Previous Message Robert Ayrapetyan 2011-08-04 17:19:03 Re: Performance die when COPYing to table with bigint PK