-2

I want to ask whether this parallel pipelined table function feature is present in postgres also or not. I am sure , pipelined table function is present in postgres, but whether they exhibit parallelism or not i dont know. Can somebody help me out with this ?

Also , Also , i want to ask , HOW parallel pipelined table functions parallelize the query.

Can somebody explain me this step wise , preferably with the help of example.

http://oraganism.wordpress.com/2010/05/18/parallel-enabled-pipelined-plsql-functions-an-old-feature-thats-new-to-me/

Abhishek Sagar
  • 1,189
  • 4
  • 20
  • 44
  • @APC:Thanks for the comments ,i am sorry if i fail to address the issue , i try my best .I am a learner ,can you please explain this where i am going wrong.I have deleted by answer for now. – Gaurav Soni Apr 15 '12 at 16:30
  • 1
    This should probably be split into two separate questions. – Jon Heller Apr 15 '12 at 16:36

2 Answers2

1

PostgreSQL 9.6+ now (to some extent) parallelizes a single query (without much effort from the user). However, since the new feature is still being ironed, how much this benefits your given query, may vary.

Community
  • 1
  • 1
Robins Tharakan
  • 2,209
  • 19
  • 17
0

PostgreSQL doesn't support parallel processing of one query - so there there are no feature like parallel pipeline functions.

Pavel Stehule
  • 42,331
  • 5
  • 91
  • 94