From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: Tom McLoughlin <tom@dynamiccreative.com>
To: pgsql-performance@postgresql.org
Subject: Re: Materialized view performance problems
Date: Wed, 6 Jan 2016 12:40:16 +0100 (CET)
Message-ID: <573633884.42831.1452080416423.JavaMail.open-xchange@oxweb01.ims-firmen.de> (raw)
In-Reply-To: <CA+dBN5Osf7gmZ0Nb4ENP5mdNU1za3m5Z4W2jPoVYPemqDH2ZbA@mail.gmail.com>
References: <CA+dBN5Osf7gmZ0Nb4ENP5mdNU1za3m5Z4W2jPoVYPemqDH2ZbA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
> Tom McLoughlin <tom@dynamiccreative.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@a-kretschmer.de, tom@dynamiccreative.com
Subject: Re: Materialized view performance problems
In-Reply-To: <573633884.42831.1452080416423.JavaMail.open-xchange@oxweb01.ims-firmen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox