Re: Performance issue

On 27/04/2004 10:12 Michael L. Hostbaek wrote:
> [snip]
> Is this normal ? If I run the same select on another table in the same
> database with ~40.000 rows, it takes approx 820.00ms...

You would probably get better answers on the correct list but my guess is 
that your fsm setting might be too low for the number of dead tuples you 
are trying to reclaim so the vacuum is not clearing all the dead stuff 
out. There's plenty of stuff about this in the archives and the docs.


-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for 
Business             |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+