Postgres Pro
Downloads
Home   >   mailing lists

What is faster? - Mailing list pgsql-general

From Mihai Gheorghiu
Subject What is faster?
Date
Msg-id 001401c13f94$7b7290e0$6e646464@New6.Travel
Whole thread Raw
List pgsql-general
Tree view 
What runs faster?
select   where   timestamp IS NOT NULL
or
select   where   boolean IS TRUE?
Does it make a significant difference if the boolean is indexed? There are
many records in the table.

Thank you for your help.

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Dropping Fields In A Table
Next
From: Stephan Szabo
Date:
Subject: Re: adding a superuser