Re: update performance - Mailing list pgsql-performance

From scott.marlowe
Subject Re: update performance
Date
Msg-id Pine.LNX.4.33.0402110909000.32376-100000@css120.ihs.com
Whole thread Raw
In response to update performance  (stefan bogdan <sbogdan@rsb.ro>)
Responses Re: update performance
List pgsql-performance
On Wed, 11 Feb 2004, stefan bogdan wrote:

> hello
> i have postgres 7.3.2.,linux redhat 9.0
> a database,and 20 tables
> a lot of fields are char(x)
> when i have to make update for all the fields except index
> postgres works verry hard
> what should i've changed in configuration to make it work faster

1:  Upgrate to 7.3.5, (or 7.4.1 if you're feeling adventurous)
2:  Read this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html


pgsql-performance by date:

Previous
From: Chris Browne
Date:
Subject: Re: slow database
Next
From: Tom Lane
Date:
Subject: Re: slow database