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 <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
