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
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.
In response to
pgsql-performance by date
|Next:||From: Ofer Israeli||Date: 2012-02-20 19:21:12|
|Subject: Re: Insertions slower than Updates?|
|Previous:||From: Ofer Israeli||Date: 2012-02-20 18:59:36|
|Subject: Insertions slower than Updates?|