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.
You might want to look in the manuals for NOTIFY and LISTEN.
a few other questions
Q1. is there anyway by which we can give priorities to the transactions?
No. It's not clear that the idea makes sense in general (though it might for specific examples). You can of course tune settings to favour inserts over selects, or favour large sorts etc.
Q2. is there s concept of connection pool in postgres?
Google for pgpool by Tatsuo Ishii
Q3. does postgres support multi threading? if yes how?
In the client or the server? Which client? From what point of view?
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
