On Mon, 2007-01-15 at 23:26, Tom Lane wrote: > "carter ck" <carterck32@xxxxxxxxxxx> writes: > > And you are definitely right when updating the table. The time it takes is > > getting longer and longer. When I do a select statement, the speed has also > > degraded. > > Seems like you need a VACUUM in there somewhere... If he hasn't been vacuuming up until now, he'll need a vacuum full. then regular vacuums.