Re: [SQL] short query becomes long

2000-06-01 Thread Tom Lane
mikeo <[EMAIL PROTECTED]> writes: > after about 50,000 updates, which fly right along, the process begins > to really bog down. we perform a vacuum analzye and it speeds right > up again. A plain "vacuum" should do the job in a bit less time. The problem is you need to reclaim the space occupie

[SQL] short query becomes long

2000-06-01 Thread mikeo
hi, we have a weird situation here. we have a table of approx. 10k rows representing accumulated activity by specific customers. as information is gathered those customers rows are updated. the number of rows does not increase unless we get a new customer so that is not a factor. the table