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.