Home > mailing lists

Re: Speed difference between != and = operators? - Mailing list pgsql-general

From	Tom Lane
Subject	Re: Speed difference between != and = operators?
Date	July 31, 2000 19:11:36
Msg-id	12847.965074255@sss.pgh.pa.us Whole thread Raw
In response to	Speed difference between != and = operators? (Paul Caskey <paul@nmxs.com>)
List	pgsql-general

Tree view

Paul Caskey <paul@nmxs.com> writes:
> This query takes 206 seconds:
> [snip]
> If I change the last line to this, it takes 1 second:

What does EXPLAIN show for these queries?

            regards, tom lane

pgsql-general by date:

From: Felipe Alvarez Harnecker
Date: 31 July 2000, 19:11:26
Subject: Re: select question -- SOLVED

From: "Bryan White"
Date: 31 July 2000, 19:15:07
Subject: Re: Corrupted Table

Re: Speed difference between != and = operators? - Mailing list pgsql-general

Previous

Next