Re: UPDATE on two large datasets is very slow

From: Listmail <lists(at)peufeu(dot)com>
To: "Steve Gerhardt" <ocean(at)ocean(dot)fraknet(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UPDATE on two large datasets is very slow
Date: 2007-04-04 20:31:17
Message-ID: op.tp90mfnszcizji@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Any suggestions for finding out where all the time is being spent? I'm

- time spent updating indexes ? do you have a lot of them ?
- try with fsync off (not in production, but it will give you an idea)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2007-04-04 22:15:04 dropping role w/dependent objects
Previous Message Listmail 2007-04-04 20:25:56 Re: Storing blobs in PG DB