On 15/11/14 15:08, Jim Nasby wrote:
On 11/14/14, 5:00 PM, Mark Kirkwood wrote:
as the 'rule of thumb' for setting shared_buffers. However I was
recently benchmarking a machine with a lot of ram (1TB) and entirely
SSD storage [1], and that seemed quite happy with 50GB of shared
buffers (better p
On 11/7/14, 5:14 AM, Artūras Lapinskas wrote:
thanks for your time and answer. Not treating IS NULL as equality operator
definitely helps me to make more sense out of previous explains.
You can also try creating a partial index WHERE b IS NULL. WHERE b IS NOT NULL
can also sometimes be useful
On 11/14/14, 5:00 PM, Mark Kirkwood wrote:
as the 'rule of thumb' for setting shared_buffers. However I was recently
benchmarking a machine with a lot of ram (1TB) and entirely SSD storage [1], and
that seemed quite happy with 50GB of shared buffers (better performance than with
8GB). Now sha
On 11/10/14, 4:52 PM, Eric Ramirez wrote:
Hi Matteo,
Thanks for your suggestions, I just run some test with ILIKE and LIKE, and
ILIKE is consistently slower so I think I will keep the Lower functions. As
per your suggestion, I have switched indexes to use GIN type index, they seem
to build/r
On 15/11/14 06:06, Shaun Thomas wrote:
Alexey,
The issue is not that 8GB is the maximum. You *can* set it higher. What I'm
saying, and I'm not alone in this, is that setting it higher can actually
decrease performance for various reasons. Setting it to 25% of memory on a
system with 512GB of
Fri, 14 Nov 2014 17:06:54 + от Shaun Thomas :
> Alexey,
>
> The issue is not that 8GB is the maximum. You *can* set it higher. What I'm
> saying, and I'm not alone in this, is that setting it higher can actually
> decrease performance for various reasons. Setting it to 25% of memory on a
Alexey,
The issue is not that 8GB is the maximum. You *can* set it higher. What I'm
saying, and I'm not alone in this, is that setting it higher can actually
decrease performance for various reasons. Setting it to 25% of memory on a
system with 512GB of RAM for instance, would be tantamount to
Fri, 14 Nov 2014 16:28:16 + от Shaun Thomas :
> Alexey,
>
> The issue is that the 1/4 memory suggestion hasn't been a recommendation in
> quite a while. Now that much larger amounts of RAM are readily available,
> tests have been finding out that more than 8GB of RAM in shared_buffers has
Alexey,
The issue is that the 1/4 memory suggestion hasn't been a recommendation in
quite a while. Now that much larger amounts of RAM are readily available, tests
have been finding out that more than 8GB of RAM in shared_buffers has
diminishing or even worse returns. This is true for any versi
> From: Filip Rembiałkowski
>To: pgsql-performance@postgresql.org
>Sent: Thursday, 13 November 2014, 8:10
>Subject: [PERFORM] 9.0 performance degradation with kernel 3.11
>
>
>Hi
>
>After upgrading our 9.0 database server
>
>from:
>openSUSE 11.4, kernel 2.6.37.6-24-default, Pg 9.0.13
>
>to:
>ope
Fri, 7 Nov 2014 14:13:20 + от Shaun Thomas :
>> Yeah, pgTune is pretty badly out of date. It's been on my TODO list, as
>> I'm sure it has been on Greg's.
>
>Yeah. And unfortunately the recommendations it gives have been spreading. Take
>a look at the online version:
>
>http://pgtune.leopard
11 matches
Mail list logo
