At 07:39 PM 2/11/2002 +1100, Philip Warner wrote:
To give some numbers:
And some more numbers, directly after a vacuum and analyze:
mail=# explain analyze select * from often_updated where id between
'-1' and '10';
Index Scan using barnet_users_id on often_updated (cost=0.00..3095.66
Philip Warner [EMAIL PROTECTED] writes:
At 07:39 PM 2/11/2002 +1100, Philip Warner wrote:
The latter time is actually quote good; when the machine is more
heavily loaded it goes up to 1ms.
We currently vacuum/analyze daily, and analyze hourly.
Why not vacuum hourly (regular