Sorry this took so long to get back to you. Here is where we were:
I said: <<
So, this query is not called often, but the fact is that if it takes over 30
seconds to load an item (because the audit report takes so long to prepare
the bitmap index scan when passed new query parameters) then it sev
On Fri, 08 Mar 2013 20:39:45 +0200, AI Rumman wrote:
Knowing your problem, I read the docs and found that :
*
*
*Fix performance problems with autovacuum truncation in busy workloads
(Jan
Wieck)*
*Truncation of empty pages at the end of a table requires exclusive lock,
but autovacuum was c
On 7 March 2013 18:47, Tom Lane wrote:
> Good idea, but no such luck in that form: it's still not going to try to
> push the parameterization down into the sub-query. I think you'd have
> to write out the query with the views expanded and manually put the
> WHERE restrictions into the lowest join
Hi,
I upgraded our master database server from 9.2.2 to 9.2.3 on Monday. We
have been experiencing performance problems since then. Yesterday, our
application hit the connection limit 5 times. It causes approximately
15 seconds of downtime. The database server hit 50 load average, then
everything
On 2013-03-08 07:48, CSS wrote:
http://www.anandtech.com/show/6433/intel-ssd-dc-s3700-200gb-review
Of most interest to me was this:
Anyone have any benchmarks to share?
I tested the 800GB disk with diskchecker.pl and it was ok. No benchmarks
to share yet, as I'm waiting for the disks to be
