On 18/06/2004 12:31 Gary Cowell wrote:
[snip] I'm not as familiar with postgresql as I am with Oracle but I think I've configured comparible buffering and sort area sizes, certainly there isn't much physical IO going on in either case.
What can I do to speed up this query? Other queries are slightly slower than under Oracle on the same hardware but nothing like this.
Usual questions:
have you vacuumed the table recently? what are your postgresql.conf settings? can you show us explain ANALYZE output rather than just explain output?
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
