Re: indexes across joins not used for count

From: Jeremy Wells <jemmyw(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: indexes across joins not used for count
Date: 2012-10-21 21:30:39
Message-ID: 5084697F.8070806@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom Lane wrote:
> (Or, perhaps, you
> are using a version too old to be able to use an index for IS NULL?
> You didn't mention your PG version, which is a fundamental mistake in
> any performance-related question.)
I'm using 9.1

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Gerhard Peters 2012-10-23 13:16:32 Error 1935 An error
Previous Message Tom Lane 2012-10-21 16:59:16 Re: indexes across joins not used for count