Search Postgresql Archives

Re: UPDATE on two large datasets is very slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Steve Gerhardt" <ocean@xxxxxxxxxxxxxxxxx>, "Tom Lane" <tgl@xxxxxxxxxxxxx>
Subject: Re: UPDATE on two large datasets is very slow
From: Listmail <lists@xxxxxxxxxx>
Date: Wed, 04 Apr 2007 22:31:17 +0200
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <4612DDDE.3060704@xxxxxxxxxxxxxxxxx>
References: <4611C8FE.8030407@xxxxxxxxxxxxxxxxx> <10105.1175621675@xxxxxxxxxxxxx> <4612DDDE.3060704@xxxxxxxxxxxxxxxxx>
User-agent: Opera Mail/9.10 (Linux)

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)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- UPDATE on two large datasets is very slow
  - From: Steve Gerhardt
- Re: UPDATE on two large datasets is very slow
  - From: Tom Lane
- Re: UPDATE on two large datasets is very slow
  - From: Steve Gerhardt

Prev by Date: Re: Storing blobs in PG DB
Next by Date: dropping role w/dependent objects
Previous by thread: Re: UPDATE on two large datasets is very slow
Next by thread: Re: UPDATE on two large datasets is very slow
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux