Postgres Pro
Downloads
Home   >   mailing lists

Re: updates way slower than selects? - Mailing list pgsql-general

From Tom Lane
Subject Re: updates way slower than selects?
Date
Msg-id 4393.987179446@sss.pgh.pa.us
Whole thread Raw
In response to Re: updates way slower than selects?  (Marek Pętlicki <marpet@buy.pl>)
Responses Re: updates way slower than selects?
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Repairing bad table?
Next
From: Tom Lane
Date:
Subject: Re: Question about SELECT FOR UPDATE in transaction, isolation level