From: | "Rainer Mager" <rmager(at)vgkk(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: Slow access with PG 7.0 |
Date: | 2000-12-06 22:57:12 |
Message-ID: | NEBBJBCAFMMNIHGDLFKGMEEBCIAA.rmager@vgkk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Alfred Perlstein
Sent: Thursday, December 07, 2000 2:25 AM
To: Jean-Arthur Silve
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Slow access with PG 7.0
* 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bryan Bateman | 2000-12-07 00:01:19 | Re: Lost socket connection |
Previous Message | Stefan Huber | 2000-12-06 18:33:23 | Re: Lost socket connection |