[GENERAL] SPI functions to work with the Execution Plan

2012-02-15 Thread Osmel Barreras Piñera
Thanks for answering:

I am a member of the PostgreSQL development community here in Cuba. My proposal 
is to develop an extension to PostgreSQL that allows query execution using 
multiple threads. The central idea is to get the execution plan ready to run, 
but send him to run with the same postgres executor concurrently with the help 
of a C library that handles the job with the user-level threads and kernel 
level.
I would appreciate any solution or suggestion that you could help me to fulfill 
this goal.
Is there any query to return the plan or any similar data structure?




Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE 
ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

-- 
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] SPI functions to work with the Execution Plan

2012-02-05 Thread Tom Lane
Osmel Barreras =?utf-8?Q?Pi=C3=B1era?=  writes:
> I need to develop for my diploma thesis an extension that allows me to travel 
> the implementation plan once you pass through the phase of planning and 
> optimization. SPI functions that could be used to obtain and work with the 
> plan?

SPI is not meant to expose anything like that.  You could install a
planner_hook though, and look at the plan after calling standard_planner.

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] SPI functions to work with the Execution Plan

2012-02-05 Thread Osmel Barreras Piñera

I need to develop for my diploma thesis an extension that allows me to travel 
the implementation plan once you pass through the phase of planning and 
optimization. SPI functions that could be used to obtain and work with the plan?


Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE 
ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general