Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance die when COPYing to table with bigint PK - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Performance die when COPYing to table with bigint PK
Date
Msg-id 4E3A8F07020000250003FA72@gw.wicourts.gov
Whole thread Raw
In response to Performance die when COPYing to table with bigint PK  (Robert Ayrapetyan <robert.ayrapetyan@comodo.com>)
Responses Re: Performance die when COPYing to table with bigint PK
List pgsql-performance
Tree view 
Robert Ayrapetyan <robert.ayrapetyan@comodo.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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Need to tune for Heavy Write
Next
From: Samuel Gendler
Date:
Subject: Re: Need to tune for Heavy Write