On Friday 11 Feb 2005 6:01 pm, Surabhi Ahuja wrote: > does postgres support notifications. > > for eg. through one connection to the server, i begin a transaction and i > do inserts there. in another sessions, i want to get notified that inserts > are taking place in someother session. please help.
Umm.. out of box, I don't think so. May be some triggers etc. can be placed for information..Can you describe what you are trying to achieve? > a few other questions > > Q1. is there anyway by which we can give priorities to the transactions? You need priorities to connections or transactions? > Q2. is there s concept of connection pool in postgres? Yes. See pgpool(http://pgfoundry.org/projects/pgpool/) > Q3. does postgres support multi threading? if yes how? No. PostgreSQL backend process is single threaded. However each connection gets a separate backend process. Hence on SMP machines, all available CPUs can potentially be used for multiple connections. Regards, Shridhar ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
