Re: What popular, large commercial websites run
От | postgres@vrane.com |
---|---|
Тема | Re: What popular, large commercial websites run |
Дата | |
Msg-id | 20020501191947.A2727@amd.universe обсуждение исходный текст |
Ответ на | Re: What popular, large commercial websites run ("Nigel J. Andrews" <nandrews@investsystems.co.uk>) |
Ответы |
Re: What popular, large commercial websites run
Re: What popular, large commercial websites run |
Список | 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 по дате отправления: