sql-performance@postgresql.org
> Subject: [PERFORM] Troubleshooting query performance issues
>
> I spent about a week optimizing a query in our performance-testing
> environment, which has hardware similar to production.
>
> I was able to refactor the query and reduce the runtime from hours t
.@postgresql.org [mailto:pgsql-
> performance-ow...@postgresql.org] On Behalf Of Jim Garrison
> Sent: Wednesday, September 25, 2013 8:58 AM
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] Troubleshooting query performance issues
>
> I spent about a week optimizing a query in our
On Wed, Sep 25, 2013 at 8:58 AM, Jim Garrison wrote:
> I spent about a week optimizing a query in our performance-testing
> environment, which has hardware similar to production.
>
> I was able to refactor the query and reduce the runtime from hours to
> about 40 seconds, through the use of CTEs
I spent about a week optimizing a query in our performance-testing environment,
which has hardware similar to production.
I was able to refactor the query and reduce the runtime from hours to about 40
seconds, through the use of CTEs and a couple of new indexes.
The database was rebuilt and ref
