Re: [PERFORM] High %SYS CPU usage

2012-11-02 Thread Cesar Martin
Hi Josh, Today is not the worse day for this issue, because Fridays DB have little workload... But I have this output: http://pastebin.com/bKg8tfKC I don't have updated OS server from the install. I also begin to think that the problem is OS misconfiguration (Kernel parameters??) or Hardware pro

Re: [PERFORM] dbt2 performance regresses from 9.1.6 to 9.2.1

2012-11-02 Thread Ants Aasma
On Thu, Nov 1, 2012 at 12:51 AM, Dong Ye wrote: > The average notpm is 61384.24 with 9.1.6 and 57381.43 with 9.2.1. > Plotting notps over time shows that the slowdown of 9.2.1 is evident across > the entire run period. > Since we also observed sustained 80+% CPU utilization during both runs, we

[PERFORM] Constraint exclusion in views

2012-11-02 Thread Claudio Freire
Hi list. I've been battling with a design issue here. I have postgres 9.0.x deployed in some databases, and was designing some changes that involve querying in a very partition-like way, but not quite. In particular, I have a few tables (lets call them table1...tableN). N is pretty small here, b