> Tom McLoughlin <tom@xxxxxxxxxxxxxxxxxxx> hat am 6. Januar 2016 um 09:08 > geschrieben: > > > > As you can see below it's a big query, and I didn't want to overwhelm > everyone with the schema, so let me know what bits you might need to help! > > Any help improving the performance will be greatly appreciated. can you show us the EXPLAIN ANALYSE - Output? I see a LOT of seq-scans, maybe you should create some indexes. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
