Re: updates way slower than selects?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marek Pętlicki <marpet(at)buy(dot)pl>
Cc: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: updates way slower than selects?
Date: 2001-04-13 16:30:46
Message-ID: 4393.987179446@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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?

Updates naturally take longer than inserts. Especially if you haven't
provided an index that allows the row(s) to be updated to be found
easily. Have you checked the EXPLAIN results for your problem queries?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-13 16:36:58 Re: PostgreSQL v7.1 Release Candidate 4
Previous Message Tom Lane 2001-04-13 16:22:22 Re: Question about SELECT FOR UPDATE in transaction, isolation level