| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Aaron Bono <postgresql(at)aranya(dot)com> |
| Cc: | PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Query Join Performance |
| Date: | 2007-04-25 17:59:48 |
| Message-ID: | 462F9714.8090802@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Aaron Bono wrote:
> Performance tanks with this query - it takes over 120 seconds (that is
> where
> I set the timeout).
> BTW, on our Linux box the full query we run (which adds 3 more tables on
> the
> whole operation along with more filtering on the zip table) finishes in
> under 10 seconds. Problem is our development is on Windows and this is a
> real pain for developers to test.
So what's different between the systems. Obvious things to look at:
1. EXPLAIN ANALYSE outputs to show the plans (these presumably are
different, but in what details, and why?)
2. Configuration (particularly memory/cost settings).
3. Hardware.
4. Locale/encoding - these can affect index usage and sorting.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Albright | 2007-04-25 18:10:09 | sql wrapped plpgsql set returning function |
| Previous Message | Michael Fuhr | 2007-04-25 14:16:56 | Re: Which function transform x,y to latitude/longitude? |