| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Gary Cowell <gary_cowell(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Major differences between oracle and postgres performance - what can I do ? |
| Date: | 2004-06-18 12:09:27 |
| Message-ID: | 20040618130927.A17585@bacon |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2004-06-18 12:14:22 | Re: Major differences between oracle and postgres performance - what can I do ? |
| Previous Message | Richard Huxton | 2004-06-18 12:07:15 | Re: Major differences between oracle and postgres performance |