Обсуждение: update performance

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

thanks
bogdan

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

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

On Wed, 11 Feb 2004, scott.marlowe wrote:

> 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

As a followup, do you have mismatched foreign keys or big ugly
constraints?  Sometimes those can slow things down too.