On Mon, Oct 1, 2012 at 5:15 PM, Stefan Keller wrote:
> Sorry for the delay. I had to sort out the problem (among other things).
>
> It's mainly about swapping.
Do you mean ordinary file IO? Or swapping of an actual process's
virtual memory? The latter shouldn't happen much unless you have
somet
I am posting back to let you know that the DB is working fine since the changes
in the autovacuum settings.
I am including the changes I made for later reference to anyone that may face
similar issues.
Thank you all for your time and help !
On Sep 28, 2012, at 9:52, Kiriakos Tsourapas wrote:
- Original Message -
> From: David Boreham
> To: "pgsql-performance@postgresql.org"
> Cc:
> Sent: Tuesday, 2 October 2012, 16:14
> Subject: Re: [PERFORM] hardware advice
>
> On 10/2/2012 2:20 AM, Glyn Astill wrote:
>> newer R910s recently all of a sudden went dead to the world; no pri
Hi
On 09/18/2012 09:44 AM, Andrea Suisani wrote:
On 09/14/2012 10:45 AM, Daniel Farina wrote:
On Fri, Sep 14, 2012 at 12:40 AM, Nikolay Ulyanitsky wrote:
Hi
I compiled the 3.6-rc5 kernel with the same config from 3.5.3 and got
the 15-20% performance drop of PostgreSQL 9.2 on AMD chipsets (880
That fixed it :)
The 9.2 query plan for reference:
Sort (cost=439.67..439.74 rows=30 width=503) (actual time=0.754..0.756 rows=49
loops=1)
Sort Key: s0_m0_msubjobs.creation_mdate, s0_m1_mjob.__id, s0_m0_msubjobs.__id
Sort Method: quicksort Memory: 31kB
-> Hash Join (cost=23.45..438.93
