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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly