Re: a few doubts regarding postgres

From: Richard Huxton <dev(at)archonet(dot)com>
To: Surabhi Ahuja <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a few doubts regarding postgres
Date: 2005-02-11 13:06:45
Message-ID: 420CADE5.4090004@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-02-11 13:11:11 Re: a few doubts regarding postgres
Previous Message Shridhar Daithankar 2005-02-11 12:47:28 Re: a few doubts regarding postgres