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
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
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,
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
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
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
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
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
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
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
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
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
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
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)
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
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
16 matches
Mail list logo