On Mon, 2007-01-15 at 23:26, Tom Lane wrote: > "carter ck" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: 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