Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
This is my env: postgres@backup:~$ env MANPATH=:/opt/PostgreSQL/9.1/share/man SHELL=/bin/bash TERM=linux USER=postgres LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/ PGPORT=3500

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Scott Marlowe
Wow, you got me. On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter ruralhun...@gmail.com wrote: This is my env: postgres@backup:~$ env MANPATH=:/opt/PostgreSQL/9.1/share/man SHELL=/bin/bash TERM=linux USER=postgres LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/ PGPORT=3500

[ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Hi all, I came across http://www.postgresql.org/docs/8.4/static/runtime-config-query.html which describes how to change query planner configuration paramerters. I need to know how I can change these parameters. For example if I need to turn off enable_hashjoin, how can I do that? Best Regards,

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Richard Shaw
Tried adding the path to ldconfig rather than redefining ld_library_path? On 18 Sep 2011, at 09:03, Scott Marlowe scott.marl...@gmail.com wrote: Wow, you got me. On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter ruralhun...@gmail.com wrote: This is my env: postgres@backup:~$ env

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Raghavendra
postgres=# set enable_hashjoin to off; SET postgres=# show enable_hashjoin; enable_hashjoin - off (1 row) Above, changes applies for the current session (its Session-Level). If you want to do at Database-level use ALTER DATABASE and for entire Cluster-level edit postgresql.conf

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Hi Raghavendra, Thanks for your quick reply, I did as you suggessted and following is my output. melaka=# set enable_mergejoin to off; SET melaka=# show enable_mergejoin; enable_mergejoin -- off (1 row) Then I executed the following query melaka=# EXPLAIN select * from

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
yes, tried that too and same thing happened. 于2011年9月18日 17:09:25,Richard Shaw写到: Tried adding the path to ldconfig rather than redefining ld_library_path? On 18 Sep 2011, at 09:03, Scott Marlowescott.marl...@gmail.com wrote: Wow, you got me. On Sun, Sep 18, 2011 at 12:56 AM, Rural

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Craig Ringer
On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: Merge Full Join (cost=174.40..193.69 rows=1159 width=286) Can you suggest why the merge join is being suggested when I have turned it off ? AFAIK SETting a join type to off really just increases the cost estimate so high

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Peter Eisentraut
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote: This is my env: postgres@backup:~$ env MANPATH=:/opt/PostgreSQL/9.1/share/man SHELL=/bin/bash TERM=linux USER=postgres LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/ PGPORT=3500

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
I didn't install anything else there: postgres@backup:~$ ls -l /opt/PostgreSQL/9.1/lib/ Total 9804 -rwxr-xr-- 1 root daemon 1366272 2011-09-09 13:45 libcrypto.so.6 -rw-r--r-- 1 root daemon 149938 2011-09-09 13:44 libecpg.a -rw-r--r-- 1 root daemon 18852 2011-09-09 13:44 libecpg_compat.a

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Peter Eisentraut
On sön, 2011-09-18 at 22:41 +0800, Rural Hunter wrote: I didn't install anything else there: (for a very small value of anything else) It looks like you have some version of libncurses in there, which is prone to interfere with the operating system installation. I suppose you got this

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Ray Stell
On Sun, Sep 18, 2011 at 10:47:39AM +0800, Rural Hunter wrote: Any suggestion? I don't do ubuntu this week, so I may be out to lunch, but why don't you append to the system set value of the var. In RH (this week) we do this in /etc/profile.d/localpath.sh but shirley ubuntu has some means for

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Tom Lane
Craig Ringer ring...@ringerc.id.au writes: On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: Merge Full Join (cost=174.40..193.69 rows=1159 width=286) Can you suggest why the merge join is being suggested when I have turned it off ? AFAIK SETting a join type to off really

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Thanks for the information Tom. It solved my confusion. On Sun, Sep 18, 2011 at 10:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Craig Ringer ring...@ringerc.id.au writes: On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: Merge Full Join (cost=174.40..193.69 rows=1159 width=286)

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
Well, I installed pg by the official one-click graphic installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's now working without this variable. The variable was added into my env for 9.1rc. If I

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Scott Marlowe
On Sun, Sep 18, 2011 at 8:00 PM, Rural Hunter ruralhun...@gmail.com wrote: Well, I installed pg by the official one-click graphic installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's now