From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
---|---|
To: | Savita <savita(at)india(dot)hp(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DISABLING THE NESTED Loop |
Date: | 2002-10-30 09:37:57 |
Message-ID: | B9E558F5.A64B%a.witney@sghms.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Myrta | 2002-10-30 09:44:06 | Re: [SQL] Database Design tool |
Previous Message | Bhuvan A | 2002-10-30 09:15:41 | Re: Database Design tool |