On Tue, Feb 26, 2013 at 4:29 PM, Josh Berkus wrote:
> Andre,
>
> Please see the related thread on this list, "High CPU usage / load
> average after upgrading to Ubuntu 12.04". You may be experiencing some
> of the same issues. General perspective seems to be that kernels 3.0
> through 3.4 have s
<>
All writes are single row. All DB's have exactly the same structure, only
the content is different. Currently the server is hosting five active DB's -
although there 14 DB's actually on the host, the balance are backups and or
testing environments.
When a feed comes in, it can be anythi
Andre,
Please see the related thread on this list, "High CPU usage / load
average after upgrading to Ubuntu 12.04". You may be experiencing some
of the same issues. General perspective seems to be that kernels 3.0
through 3.4 have serious performance issues.
--
Josh Berkus
PostgreSQL Experts
On Tue, Feb 26, 2013 at 2:30 PM, Jeff Janes wrote:
> On Fri, Feb 15, 2013 at 10:52 AM, Scott Marlowe
> wrote:
>>
>> On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus wrote:
>> > On 02/14/2013 08:47 PM, Scott Marlowe wrote:
>> >> If you run your benchmarks for more than a few minutes I highly
>> >> r
On Fri, Feb 15, 2013 at 10:52 AM, Scott Marlowe wrote:
> On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus wrote:
> > On 02/14/2013 08:47 PM, Scott Marlowe wrote:
> >> If you run your benchmarks for more than a few minutes I highly
> >> recommend enabling sysstat service data collection, then you can
Howdy, the query generator in my app sometimes creates redundant
filters of the form:
project_id IN ( ) AND
project_id =
... and this is leading to a bad estimate (and thus a bad plan) on a
few complex queries. I've included simplified examples below. This
server is running 9.0.10 and the stati
On Mon, Feb 25, 2013 at 9:04 AM, Carlo Stonebanks <
stonec.regis...@sympatico.ca> wrote:
> Hi Jeff, thanks for the insight.
>
> ** **
>
> << And then the next question would be, once they are in the cache, why
> don't they stay there? For that you would have to know what other types of
> acti
On 25/02/2013 12:45 AM, Tom Lane wrote:
Odd. I wonder if you are seeing some variant of the old context swap storm problem. The "99.8% system time" reading is suggestive but hardly conclusive. Does top's report of context swap rate go to the moon? It would be interesting to strace a few of the ser
Hello Merlin,
thanks for the feedback, I forwarded this to my developer, this is an
interesting approach.
--
Best regards
Florian Schröck
On 02/19/2013 09:04 PM, Merlin Moncure wrote:
> On Fri, Feb 15, 2013 at 9:32 AM, Florian Schröck wrote:
>> Hello Kevin,
>> not updating every row which do
