On 30/03/2009 07:18, aravind chandu wrote: > Thanks for your reply guys.My aim is to run multiple queries.Will > joins come under multiple queries? or it just mean two or more Not sure what you're getting at here....a query that includes a JOIN is still one query. > different queries like one select statement and another select > statement? Does postgresql itself supports to run multiple queries or > we have to use pgpool-II tool? PostgreSQL spawns a new process for each connection, and runs these in parallel. Within each connection, a client can run as many queries as it likes; and these are going on at the same time as queries in other connections. You should read the part of the docs that talks about MVCC to understand how each process sees its own snapshot of the data. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
