Re: 8.x index insert performance - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: 8.x index insert performance
Date
Msg-id 4374CDA90200002500000651@gwmta.wicourts.gov
Whole thread Raw
In response to 8.x index insert performance  (Kelly Burkhart <kelly@tradebotsystems.com>)
List pgsql-performance
That sure seems to bolster the theory that performance is degrading
because you exhaust the cache space and need to start reading
index pages.  When inserting sequential data, you don't need to
randomly access pages all over the index tree.

-Kevin


>>> Kelly Burkhart <kelly@tradebotsystems.com>  >>>

I modified my original program to insert generated, sequential data.
The following graph shows the results to be flat:

<http://kkcsm.net/pgcpy_20051111_1.jpg>


pgsql-performance by date:

Previous
From: Kelly Burkhart
Date:
Subject: Re: 8.x index insert performance
Next
From: Tom Lane
Date:
Subject: Re: 8.x index insert performance