From: Richard Huxton <dev@archonet.com>
To: stefan bogdan <sbogdan@rsb.ro>
To: pgsql-performance@postgresql.org
Subject: Re: update performance
Date: Wed, 11 Feb 2004 15:53:57 +0000
Message-ID: <200402111553.57724.dev@archonet.com> (raw)
In-Reply-To: <402A3747.8000906@rsb.ro>
References: <402A3747.8000906@rsb.ro>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, sbogdan@rsb.ro
Subject: Re: update performance
In-Reply-To: <200402111553.57724.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox