Postgres Pro
Downloads
Home   >   mailing lists

Re: update performance - Mailing list pgsql-performance

From Richard Huxton
Subject Re: update performance
Date
Msg-id 200402111553.57724.dev@archonet.com
Whole thread Raw
In response to update performance  (stefan bogdan <sbogdan@rsb.ro>)
List pgsql-performance
Tree view 
On Wednesday 11 February 2004 14:08, 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

Stefan - we need more information to help you. We'll want to know:
1. The query being run
2. EXPLAIN ANALYSE ... results for that query
3. The size of the tables involved.
4. That the tables have been VACCUM ANALYSE'd

PS - you should upgrade to 7.3.4 (or is it 7.3.5 now?)

--
  Richard Huxton
  Archonet Ltd

pgsql-performance by date:

Previous
From: Chris Trawick
Date:
Subject: Re: slow database
Next
From: "scott.marlowe"
Date:
Subject: Re: select count(*) from anIntColumn where int_value = 0;