I have a few questions:
1. what is pg_xlog
someone told me that i can move pg_xlog to a different parttion in order to boost the performance? Does it work and how
2. there is a parameter in postgresql.conf called max_connections. which is 100 be default. i want o decrease it to 20.
by doing this how much can i increase the value of shared buffers?
by default it is 1000, how much can i increase to in order to boost up the performance
3. What other things can i do to boost up the performance assuming that the stored procedures are well optimized.
4. I recently tried to start postmaster. But it simply timed out. i tried to find out if there is any postmaster process running, but it was not running.
my question is that can u decrease this timeout, right now i think it takes some 1 or 2 minutes...
5. i have also seen multiple instances of postmaster.
in my script ot start postmaster i first check if it is running by doing pidof, and only if it is nor running i start it
still have seen multiple instances.
how did that happen? also if i stop postmaster, only one instance is stopped.
is there any command to stop all instances of postmaster
6. what does ipcclean do? how do i know what shared memory was used by postmaster so that i can clear it, before starting postmaster
7. some times if i do a dropdb abc(assuming abc is a database)
it displays a message can not remove directory 12345, although the database is dropped, what shuld be done in such a case?
thanks,
regards
Surabhi