Re: select count(*) from anIntColumn where int_value = 0;

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: Rigmor Ukuhe <rigmor(dot)ukuhe(at)finestmedia(dot)com>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select count(*) from anIntColumn where int_value = 0;
Date: 2004-02-11 16:02:18
Message-ID: Pine.LNX.4.33.0402110901580.32376-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 11 Feb 2004, David Teran wrote:

> Hi,
>
> > Is your int_value data type int4? If not then use "... from
> > job_property
> > where int_value = '0'"
> > Indexes are used only if datatypes matches.
> >
> tried those variations already. Strange enough, after dropping and
> recreating the index everything worked fine.

Has that table been updated a lot in its life? If so, it may have had a
problem with index bloat...

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2004-02-11 16:10:53 Re: update performance
Previous Message Richard Huxton 2004-02-11 15:53:57 Re: update performance