Re: What popular, large commercial websites run - Mailing list pgsql-general

From postgres@vrane.com
Subject Re: What popular, large commercial websites run
Date
Msg-id 20020501191947.A2727@amd.universe
Whole thread Raw
In response to Re: What popular, large commercial websites run  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Responses Re: What popular, large commercial websites run
Re: What popular, large commercial websites run
List pgsql-general
On Wed, May 01, 2002 at 11:54:37PM +0100, Nigel J. Andrews wrote:
>
> On Wed, 1 May 2002 postgres@vrane.com wrote:
>
> Then run
>    EXPLAIN ANALYZE SELECT * FROM TABLE <mytable> WHERE <booleanfield> = true;
>
> Then run
>    UPDATE <mytable> SET <booleanfield> = false WHERE <booleanfield> = false;
>
> (several times)
>
> What you should see is a seqscan in both plans with the final number of rows
> the same but the second will have taken longer.

I haven't tried it yet but isn't creating an index here
the logical thing to do here.  Whenever I have "where"
clause in my queries I always create an index.

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: What popular, large commercial websites run
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: What popular, large commercial websites run