Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

From: Gary Chambers <gwchamb(at)gmail(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Updates, deletes and inserts are very slow. What can I do make them bearable?
Date: 2010-10-21 02:37:26
Message-ID: AANLkTin0=a-W-3SoXgmCHPeDPebeTL9Yo5_39v+nQf6E@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Where is the FAST button for postgres updates? What parameter do I
> have to set in order to update 6000 records in under an hour?

Which version of Postgres? Have you investigated more than just two
performance tuning parameters? Does your MS Access version of the
query run any faster?

http://tinyurl.com/2fsjmv4

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mark 2010-10-21 02:41:18 Re: Composite Index question
Previous Message Tom Lane 2010-10-21 02:32:29 Re: Custom cache implemented in a postgresql C function