[GENERAL] Parallel Query Processing
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 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? From: Scott Marlowe scott.marl...@gmail.com To: aravind chandu avin_frie...@yahoo.com Cc: postgresql Forums pgsql-general@postgresql.org Sent: Wednesday, March 25, 2009 4:52:43 PM Subject: Re: [GENERAL] Parallel Query Processing On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Do you mean one query being parallelized, or multiple queries running at once? PostgreSQL provides no capability to parallelize one query into multiple processes. Multiple Queries run in parallel automatically Hello,
Re: [GENERAL] Parallel Query Processing
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 herea 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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Parallel Query Processing
You could run parallel queries across multiple servers using pgpool-II. ~Cory Coager aravind chandu said the following on 03/25/2009 04:24 PM: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Thanks, Avin. mailto:ccoa...@davisvision.com The information contained in this communication is intended only for the use of the recipient(s) named above. It may contain information that is privileged or confidential, and may be protected by State and/or Federal Regulations. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.
Re: [GENERAL] Parallel Query Processing
On Wed, 2009-03-25 at 15:52 -0600, Scott Marlowe wrote: On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Do you mean one query being parallelized, or multiple queries running at once? PostgreSQL provides no capability to parallelize one query into multiple processes. I have a tool that will allow you to manually parallelize a query (and get the right answer). That is useful for certain larger queries. I'll be publishing that a bit more visibly in next few months. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Parallel Query Processing
On Thu, Mar 26, 2009 at 05:04:29PM +, Simon Riggs wrote: On Wed, 2009-03-25 at 15:52 -0600, Scott Marlowe wrote: On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Do you mean one query being parallelized, or multiple queries running at once? PostgreSQL provides no capability to parallelize one query into multiple processes. I have a tool that will allow you to manually parallelize a query (and get the right answer). That is useful for certain larger queries. I'll be publishing that a bit more visibly in next few months. Is this snapshot cloning? If so, thanks very much for publishing it! :) If not, I'm really curious as to what it is :) On the subject of snapshot cloning, I can see, at least in broad brush strokes, how this would work for read queries, but I'm curious how (or if) it could work for writes like, for example, updates of many partitions at once. Could it? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Parallel Query Processing
On Thu, 2009-03-26 at 10:12 -0700, David Fetter wrote: On Thu, Mar 26, 2009 at 05:04:29PM +, Simon Riggs wrote: On Wed, 2009-03-25 at 15:52 -0600, Scott Marlowe wrote: On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. PostgreSQL provides no capability to parallelize one query into multiple processes. I have a tool that will allow you to manually parallelize a query (and get the right answer). That is useful for certain larger queries. I'll be publishing that a bit more visibly in next few months. Is this snapshot cloning? Basically, yes. On the subject of snapshot cloning, I can see, at least in broad brush strokes, how this would work for read queries, but I'm curious how (or if) it could work for writes like, for example, updates of many partitions at once. Could it? Yes, think so, since most writes involve first reading the data. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Parallel Query Processing
Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Thanks, Avin.
Re: [GENERAL] Parallel Query Processing
On Wed, Mar 25, 2009 at 2:24 PM, aravind chandu avin_frie...@yahoo.com wrote: Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Do you mean one query being parallelized, or multiple queries running at once? PostgreSQL provides no capability to parallelize one query into multiple processes. Multiple Queries run in parallel automatically -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general