Skip site navigation (1) Skip section navigation (2)

Re: Table UPDATE is too slow

From: Ron St-Pierre <rstpierre(at)syscor(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table UPDATE is too slow
Date: 2004-09-01 00:18:14
Message-ID: 41351546.7090600@syscor.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Thanks for everyone's comments (Thomas, Steinar, Frank, Matt, William). 
Right now I'm bench-marking the time it takes for each step
in the end of day update process and then I am going to test a few things:
- dropping most indexes, and check the full processing time and see if 
there is any noticeable performance degradation on the web-end
- wrapping the updates in a transaction, and check the timing
- combining the two
- reviewing my shared_buffers and sort_memory settings

Thanks
Ron


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-09-01 05:32:08
Subject: Re: Table UPDATE is too slow
Previous:From: Jim C. NasbyDate: 2004-08-31 22:05:03
Subject: Re: Equivalent praxis to CLUSTERED INDEX?

pgsql-general by date

Next:From: Ron St-PierreDate: 2004-09-01 00:26:37
Subject: Suppress output from psql?
Previous:From: Matthew T. O'ConnorDate: 2004-08-31 23:44:33
Subject: Re: Multicolumn Primary Key

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group