[ADMIN] Is Posgresql and Interchange multithreaded?

Is Postgresql multithreaded i.e can it take advantange of multiprocessor systems (4 ways)? Is Interchange written as multithreaded application? What is the most processors you have seen Postgresql running on? Jeff ---(end of broadcast)--- TIP 2:

[ADMIN] How much memory does postgresql require?

How much memory does postgresql itself require? How is memory allocated? Is memory allocated when client connections are made to specific databases and is it released when the connection has ended? Is ps or top the best way to monitor memory usage? Are there any tuning recommendations for

Re: [ADMIN] [ic] Is Posgresql and Interchange multithreaded?

Thanks to all who responded - Jeremy, Peter Chad. -Original Message- From: Gill, Jeffrey L [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 9:56 AM To: InterChange Users (E-mail); Pgsql Admin (E-mail) Subject: [ic] Is Posgresql and Interchange multithreaded? Is Postgresql

[ADMIN] separating out database files

How do you separate the postgresql database files in InterChange from the rest of the application? What is the command syntax and what files need to be modified that call and point to the database? I am researching DSN... My goal is to separate InterChange so it can exist on three

[ADMIN] Optimization questions

Specs: Server RedHat 7.1 2.4.2-2 kernal everything build with Interchange 4.8 I am learning Linux and Postgresql from scratch. 1. Can someone point me to or explain any linux kernal optimizations for redhat that can made to maximize performance of a postgresql server? I have briefly

[ADMIN] client connection

I am trying to make my first connection from a client machine to a postresql server machine. What is the correct client command syntax to connect to the server? I do not want to attempt encryption yet so I am not using SSH or stunnel - I trying the easiest configuration i.e. telnet?. Specs: