Re: Slow access with PG 7.0 - Mailing list pgsql-admin

From Alfred Perlstein
Subject Re: Slow access with PG 7.0
Date
Msg-id 20001206092437.C8051@fw.wintelcom.net
Whole thread Raw
In response to Re: Slow access with PG 7.0  (Jean-Arthur Silve <jeanarthur@eurovox.fr>)
Responses RE: Slow access with PG 7.0
List pgsql-admin
* 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.


pgsql-admin by date:

Previous
From: Christian Pauchard
Date:
Subject: ...
Next
From: "Bryan Bateman"
Date:
Subject: Lost socket connection