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.
[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.
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 |Business |
Computer Consultants |
+------------------------------+---------------------------------------------+
