update performance

From: stefan bogdan <sbogdan(at)rsb(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: update performance
Date: 2004-02-11 14:08:07
Message-ID: 402A3747.8000906@rsb.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2004-02-11 14:14:39 Re: select count(*) from anIntColumn where int_value = 0;
Previous Message PC Drew 2004-02-11 13:42:19 Re: select count(*) from anIntColumn where int_value = 0; is very slow