Re: DISABLING THE NESTED Loop

These options are defined in the postgresql.conf file:

#enable_seqscan = true
#enable_indexscan = true
#enable_tidscan = true
#enable_sort = true
#enable_nestloop = true
#enable_mergejoin = true
#enable_hashjoin = true

Or you can change them temporarily on the command line using the SET command
as you have done

Adam

> Hi,
>
> I am disabling the seqscan by
> set enable_seqscan=no;
>
> I want to know is there any way to disable merge,joins,nested loops also.
>
> --
> Best Regards
> - Savita
> ----------------------------------------------------
> Hewlett Packard (India)
> +91 80 2051288 (Phone)
> 847 1288 (HP Telnet)
> ----------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.