On Tue, Feb 19, 2013 at 4:24 PM, Josh Berkus wrote:
> ... then you'll see checkpoint "stalls" and spread checkpoint will
> actually make them worse by making the stalls longer.
Wait, if they're spread enough then there won't be a checkpoint, so to
speak. Are you saying that spreading them out me
On 20/02/13 12:24, Josh Berkus wrote:
NM, I tested lowering dirty_background_ratio, and it didn't help,
because checkpoints are kicking in before pdflush ever gets there.
So the issue seems to be that if you have this combination of factors:
1. large RAM
2. many/fast CPUs
3. a database which f
On 02/19/2013 09:51 AM, Josh Berkus wrote:
> On 02/18/2013 08:28 PM, Mark Kirkwood wrote:
>> Might be worth looking at your vm.dirty_ratio, vm.dirty_background_ratio
>> and friends settings. We managed to choke up a system with 16x SSD by
>> leaving them at their defaults...
>
> Yeah? Any setting
On 20/02/13 06:51, Josh Berkus wrote:
On 02/18/2013 08:28 PM, Mark Kirkwood wrote:
Might be worth looking at your vm.dirty_ratio, vm.dirty_background_ratio
and friends settings. We managed to choke up a system with 16x SSD by
leaving them at their defaults...
Yeah? Any settings you'd recommend
On Fri, Feb 15, 2013 at 9:32 AM, Florian Schröck wrote:
> Hello Kevin,
> not updating every row which doesn't need the update solved the problem!
> Your query took only 1 minute. :)
>
> Thank you so much for the fast response, have a great weekend!
>
> PS: When you switch to "TEXT" on the explain
On 02/18/2013 08:28 PM, Mark Kirkwood wrote:
> Might be worth looking at your vm.dirty_ratio, vm.dirty_background_ratio
> and friends settings. We managed to choke up a system with 16x SSD by
> leaving them at their defaults...
Yeah? Any settings you'd recommend specifically? What did you use on
Hi Pavel,
That is what I've done in this particular case but there are parts where
I use exist checks in this way that are very cumbersome to write out
like that so I'm hoping there is a way to make the optimizer work with
existence checks in this way.
Cheers,
Bastiaan Olij
On 19/02/13 6:39 PM,
John Lumby writes:
> Meanwhile, I have one other suggestion aimed specifically at problematic
> CTEs:
> Would it be reasonable to provide a new Planner Configuration option :
> enable_nestloop_cte_inner (boolean)
> Enables or disables the query planner's use of nested-loop join plans in
