From: AndyG <andy.gumbrecht@orprovision.com>
To: pgsql-performance@postgresql.org
Subject: Re: Slow query, where am I going wrong?
Date: Tue, 30 Oct 2012 02:47:51 -0700 (PDT)
Message-ID: <1351590470163-5730025.post@n5.nabble.com> (raw)
In-Reply-To: <D960CB61B694CF459DCFB4B0128514C2089A60C2@exadv11.host.magwien.gv.at>
References: <508F82E1.3020202@orprovision.com>
<D960CB61B694CF459DCFB4B0128514C2089A60C2@exadv11.host.magwien.gv.at>
Thanks very much Laurenz.
I'll put your suggestions into motion right away and let you know the
results.
Albe Laurenz *EXTERN* wrote
> BTW, you seem to have an awful lot of indexes defined, some
> of which seem redundant.
I am in the process of pruning unused/useless indexes on this database - So
many of them will be dropped. Most of them are not in production and are
past play things on this test system.
The actual production test_item table gets about 140k inserts a day (avg).
Having this test system slow, dirty and bloated is quite good as it helps us
identify potential bottlenecks before they hit production. Partitioning is
also on the cards, but solving this current issue is only going to help.
Thanks again.
Andy
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Slow-query-where-am-I-going-wrong-tp5730015p5730025.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
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: andy.gumbrecht@orprovision.com
Subject: Re: Slow query, where am I going wrong?
In-Reply-To: <1351590470163-5730025.post@n5.nabble.com>
* 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