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 |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
