Postgres Pro
Downloads
Home   >   mailing lists

Re: B-tree performance improvements in 8.x - Mailing list pgsql-general

From Tom Lane
Subject Re: B-tree performance improvements in 8.x
Date
Msg-id 3266.1139375893@sss.pgh.pa.us
Whole thread Raw
In response to Re: B-tree performance improvements in 8.x  (Dick Kniep <dick@kniep.nl>)
Responses Re: B-tree performance improvements in 8.x  (Dick Kniep <dick@kniep.nl>)
List pgsql-general
Tree view 
Dick Kniep <dick@kniep.nl> writes:
> Does this also affect if you have many NULL values in the key? So testing Not
> is NULL would also be affected?

IS NOT NULL isn't an indexable operation, so your question doesn't really
apply :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Luki Rustianto
Date:
Subject: Is there a way to limit CPU usage per user
Next
From: Rob Newton
Date:
Subject: futex lockup?