Tom,
We have continued to explore the issue and one of my teammates,
copied, has made some interesting additional discoveries.
I apparently glossed over a subtle distinction about the query being
issued. My original reported query structure was of the form...
SELECT * FROM events WHERE entity_t
On 06/04/2014 10:55 AM, Tom Lane wrote:
Ryan Johnson writes:
I get a strange behavior across repeated runs: each 100-second run is a
bit slower than the one preceding it, when run with SSI (SERIALIZABLE).
... So the question: what should I look for to diagnose/triage this problem?
In the past
Feeling a little sorry about replying you later.
Then, I want to say so many thanks for this advice, cause we pointed our
jobserver to the master directly and then the performance issues resolved. My
client is so curious that why pgpool doesn't support so welcome platform like
java. Hoping it ca
Dear Jeff, Albe and Heikki,
Let me start by thanking you for your time. It is really nice to have a
real supportive community. Thank you.
After reading the answers, we decided to do an experiment with a
fillfactor of 40% and dropping the index on the is_grc_002 field (but
retaining the other inde
