On Mon, Oct 14, 2013 at 6:45 PM, Tomas Vondra t...@fuzzy.cz wrote:
On 15.10.2013 01:26, Tony Kay wrote:
Hi Calvin,
Yes, I have sar data on all systems going back for years.
Since others are going to probably want to be assured I am really
reading the data right:
- This is 92% user CPU
On Mon, Oct 14, 2013 at 4:42 PM, Tomas Vondra t...@fuzzy.cz wrote:
On 15.10.2013 01:00, Tony Kay wrote:
Hi,
I'm running 9.1.6 w/22GB shared buffers, and 32GB overall RAM on a
16 Opteron 6276 CPU box. We limit connections to roughly 120, but
our webapp is configured to allocate a
Thanks for the tip. I forgot there were kernel stats on spinlocks.
I'm not sure we'll be able to get it to tip in a test environment, and
we're unwilling to revert the code in production in order to have our users
trigger it. We'll try triggering it on our test server, and if we manage,
I'll get
On Tue, Oct 15, 2013 at 08:59:08AM -0700, Tony Kay wrote:
On Mon, Oct 14, 2013 at 4:42 PM, Tomas Vondra t...@fuzzy.cz wrote:
On 15.10.2013 01:00, Tony Kay wrote:
Hi,
I'm running 9.1.6 w/22GB shared buffers, and 32GB overall RAM on a
16 Opteron 6276 CPU box. We limit connections to
On Tue, Oct 15, 2013 at 10:26 AM, Julien Cigar jci...@ulb.ac.be wrote:
for two reasons:
- some of the overhead of bgwriter and checkpoints is more or less linear
in the size of shared_buffers, for example it could be possible that a
large quantity of data could be dirty when a checkpoint
On Tue, Oct 15, 2013 at 12:07:38PM -0700, Tony Kay wrote:
On Tue, Oct 15, 2013 at 10:26 AM, Julien Cigar jci...@ulb.ac.be wrote:
for two reasons:
- some of the overhead of bgwriter and checkpoints is more or less linear
in the size of shared_buffers, for example it could be possible
Hi, This is my first post ever in the Postgres forum. I am relatively new to
Postgres and coming from oracle background. We have hot stand by setup to
serve mainly the read only queries. Past few days we have been facing a
performance issues on one of the transaction search. The search mainly
On 15.10.2013 21:07, Tony Kay wrote:
On Tue, Oct 15, 2013 at 10:26 AM, Julien Cigar jci...@ulb.ac.be
mailto:jci...@ulb.ac.be wrote:
for two reasons:
- some of the overhead of bgwriter and checkpoints is more or less
linear in the size of shared_buffers, for example it could be
On Tue, Oct 15, 2013 at 12:26 PM, Julien Cigar jci...@ulb.ac.be wrote:
On Tue, Oct 15, 2013 at 08:59:08AM -0700, Tony Kay wrote:
On Mon, Oct 14, 2013 at 4:42 PM, Tomas Vondra t...@fuzzy.cz wrote:
On 15.10.2013 01:00, Tony Kay wrote:
Hi,
I'm running 9.1.6 w/22GB shared buffers, and