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