Re: updates way slower than selects?

From: Marek Pętlicki <marpet(at)buy(dot)pl>
To: Doug McNaught <doug(at)wireboard(dot)com>
Cc: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: updates way slower than selects?
Date: 2001-04-08 10:55:30
Message-ID: 20010408125530.B1578@marek.almaran.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, April, 2001-04-07 at 23:04:23, Doug McNaught wrote:
> Marek Pętlicki <marpet(at)linuxpl(dot)org> writes:
>
> > Hi!
> >
> > I've got a question: has anybody noticed in your production
> > tables, that updates on existing rows take longer than inserts
> > into those same tables?
>
> Standard first question: are you vacuuming?

this is a productio system running over half a year - yes it is
vacuumed every night. Additional question: is update speed on single
int4 value really dependant on vacuuming or are you just asking a
'standard question'?

regards and thanks

--
Marek Pętlicki <marpet(at)buy(dot)pl>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-08 11:05:38 Re: memory leaks fixed?
Previous Message Peter Eisentraut 2001-04-08 10:10:18 Re: Can timeout duration be set?