Re: Perfornamce Q

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Perfornamce Q
Date: 2003-01-23 05:25:49
Message-ID: 23381.1043299549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> Can anyone offering suggestions as to why the UPDATE takes so long and
> what I might do to make it go faster?

I think it's the foreign keys that are hurting you. Are the referenced
columns indexed? Are they of the same datatypes as the referencing
columns? Have you ANALYZEd those tables lately?

regards, tom lane

In response to

  • Perfornamce Q at 2003-01-23 05:05:59 from Jean-Christian Imbeault

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2003-01-23 05:35:27 Re: Perfornamce Q
Previous Message Jean-Christian Imbeault 2003-01-23 05:05:59 Perfornamce Q