Thread: update 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
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
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
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.