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