Home > mailing lists

Re: UPDATE on two large datasets is very slow - Mailing list pgsql-general

From	Listmail
Subject	Re: UPDATE on two large datasets is very slow
Date	April 4, 2007 20:31:58
Msg-id	op.tp90mfnszcizji@apollo13 Whole thread Raw
In response to	Re: UPDATE on two large datasets is very slow (Steve Gerhardt <ocean@ocean.fraknet.org>)
List	pgsql-general

Tree view

> 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)

pgsql-general by date:

From: Listmail
Date: 04 April 2007, 20:26:04
Subject: Re: Storing blobs in PG DB

From: "Ed L."
Date: 04 April 2007, 22:15:20
Subject: dropping role w/dependent objects

Re: UPDATE on two large datasets is very slow - Mailing list pgsql-general

Previous

Next