Re: Slow access with PG 7.0

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Slow access with PG 7.0
Date: 2000-12-06 17:24:37
Message-ID: 20001206092437.C8051@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Jean-Arthur Silve <jeanarthur(at)eurovox(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Huber 2000-12-06 18:33:23 Re: Lost socket connection
Previous Message Christian Pauchard 2000-12-06 16:43:10