| From: | "Graeme B(dot) Bell" <grb(at)skogoglandskap(dot)no> |
|---|---|
| To: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Very slow postgreSQL 9.3.4 query |
| Date: | 2014-09-26 13:55:55 |
| Message-ID: | 2E6728D4-4DB8-44F0-B75C-66F555AB1A21@skogoglandskap.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
A good way to start would be to introduce the query - describe what it is meant to do, give some performance data (your measurements of time taken, amount of data being processed, hardware used etc).
Graeme.
On 26 Sep 2014, at 15:04, Burgess, Freddie <FBurgess(at)Radiantblue(dot)com> wrote:
> Help, please can anyone offer suggestions on how to speed this query up.
>
> thanks
>
>
> <Poor Pref query.txt>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matúš Svrček | 2014-09-26 14:04:08 | after upgrade 8.4->9.3 query is slow not using index scan |
| Previous Message | Burgess, Freddie | 2014-09-26 13:04:24 | Very slow postgreSQL 9.3.4 query |