Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: scott.marloweDate: 2004-02-11 16:10:53
Subject: Re: update performance
Previous:From: Richard HuxtonDate: 2004-02-11 15:53:57
Subject: Re: update performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group