On 23/07/15 23:37, domenico febbo wrote:
is the problem also in PostgreSQL 9.4.x?
I'm going to buy a production's server with 4 sockets E7-4850 12 cores
so 12*4 = 48 cores (and 96 threads using HT).
What do you suggest?
Using or not HT?
From my experience 9.4 is considerably better (we are us
On Fri, Jul 24, 2015 at 2:40 PM, Laurent Debacker
wrote:
The Recheck Cond line is a plan-time piece of info, not a run-time piece.
> It only tells you what condition is going to be rechecked if a recheck is
> found to be necessary.
Thanks Jeff! That makes sense indeed.
>
> I'm a bit surprised
Thanks Jeff! That makes sense indeed.
I'm a bit surprised a COUNT(1) would need a bitmap heap scan since we know
the row count from the index, but okay.
Have a nice day,
Laurent
On Thu, Jul 23, 2015 at 8:04 PM, Jeff Janes wrote:
> On Thu, Jul 23, 2015 at 9:58 AM, Laurent Debacker
> wrote:
>
