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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
