RE: Slow access with PG 7.0

Can someone elaborate on this more? Is this only PHP4 related? If this
improves performance why not always have it on? What are the downsides?

Thanks,

--Rainer


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Alfred Perlstein
Sent: Thursday, December 07, 2000 2:25 AM
To: Jean-Arthur Silve
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Slow access with PG 7.0


* Jean-Arthur Silve <jeanarthur@eurovox.fr> [001206 04:55] wrote:
> Thanks for your help
> pg_exec($dbh, "set enable_seqscan off;");
> seems resolve my problem...
>
> I look at the docs, but I didn't understand very well what is the use of
> this variable ?

run:

explain <your query>

with and without the option, you'll see.