"Lim Berger" <straightfwd007@xxxxxxxxx> writes:
> Wow, you are right! The "su - postgres" showed up with wildly
> different values! Most notably, the "max user processes" is only 20!!
> Whereas in the regular user stuff it was above 14000. Would you know
> how to change this in a CentOS Linux machine? Where can I find the
> startup settings for postgresql?
Yipes, that's pretty bogus. The most likely culprit would be a .profile
or .bashrc script belonging to the postgres user --- poke around in its
home directory.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
