Skip site navigation (1) Skip section navigation (2)

Re: Insertions slower than Updates?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Ofer Israeli" <oferi(at)checkpoint(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Cc: "Netta Kabala" <nettak(at)checkpoint(dot)com>, "Olga Vingurt" <olgavi(at)checkpoint(dot)com>
Subject: Re: Insertions slower than Updates?
Date: 2012-02-20 19:13:11
Message-ID: 4F4246E702000025000458F7@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
Ofer Israeli <oferi(at)checkpoint(dot)com> wrote:
 
> INSERT should be cheaper than UPDATE due to only dealing with one 
> record instead of two.
 
... unless the UPDATE is a HOT update, in which case the indexes
don't need to be touched.
 
> Anyone have any ideas on why the empty db is giving worse
> results??
 
Besides the HOT updates being fast, there is the issue of having
space already allocated and ready for the database to use, rather
than needing to make calls to the OS to create and extend files as
space is needed.
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Ofer IsraeliDate: 2012-02-20 19:21:12
Subject: Re: Insertions slower than Updates?
Previous:From: Ofer IsraeliDate: 2012-02-20 18:59:36
Subject: Insertions slower than Updates?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group