Re: [HACKERS] explain analyze query execution time

2011-11-22 Thread Rudyar
On 22/11/11 10:26, Kevin Grittner wrote: Rudyar wrote: what tool you recommend for measure the query "real" query execution time? The -hackers list is for discussion to coordinate development of the PostgreSQL database product. For user questions like this, please pick a more a

Re: [HACKERS] explain analyze query execution time

2011-11-22 Thread Rudyar
On 22/11/11 02:58, Kevin Grittner wrote: Rudyar wrote: I try to get the execution time of a query workload. I try using explain analyze but this time is allways higher than the execution time of a query across a client like pgadmin3 what is the reason about that difference? It'

[HACKERS] explain analyze query execution time

2011-11-21 Thread Rudyar
Hello, I try to get the execution time of a query workload. I try using explain analyze but this time is allways higher than the execution time of a query across a client like pgadmin3 what is the reason about that difference? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.

Re: [HACKERS] how to get tuple

2011-11-17 Thread Rudyar
On 17/11/11 19:16, Robert Haas wrote: On Wed, Nov 16, 2011 at 9:38 AM, Rudyar wrote: Hello, I'm new in postgreSQL programming. I try to print a tuple from tupleTableSlot structure.. for example.. outerTupleSlot = ExecHashJoinOuterGetTuple(oute

[HACKERS] how to get tuple

2011-11-16 Thread Rudyar
Hello, I'm new in postgreSQL programming. I try to print a tuple from tupleTableSlot structure.. for example.. outerTupleSlot = ExecHashJoinOuterGetTuple(outerNode, node, &hashvalue); how to extract a tuple value? there are any kind

Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 13:09, Greg Smith wrote: On 11/14/2011 10:44 AM, Rudyar wrote: Ok, I'm working in that project. I will send you my results and comparision with SQL server HHJ optimization in one or two months. Please be careful not to share here details of how features like this are built i

Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 12:37, Robert Haas wrote: On Mon, Nov 14, 2011 at 10:36 AM, Rudyar wrote: On 14/11/11 12:20, Robert Haas wrote: On Mon, Nov 14, 2011 at 8:25 AM, Rudyarwrote: the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star

Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 12:20, Robert Haas wrote: On Mon, Nov 14, 2011 at 8:25 AM, Rudyar wrote: the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star join queries for Data Warehouse model? Not really. As much as possible, we try to make

[HACKERS] star join optimization

2011-11-14 Thread Rudyar
Hello, the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star join queries for Data Warehouse model? Regards. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.

[HACKERS] MPI programming in postgreSQL backend source code

2011-11-13 Thread Rudyar Cortés
Hello, I'm a new programmer in postgreSQL source code.. Is possible use MPI functions in postgreSQL source code? Help me please! Best Regards. Rudyar. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresq

[HACKERS] MPI programming in postgreSQL backend source code

2011-11-10 Thread Rudyar
do you have more documentation about OPENMP and PostgreSQL? El 09-11-2011 20:12, Greg Smith escribió: On 11/09/2011 04:10 PM, Rudyar Cortés wrote: I'm a new programmer in postgreSQL source code.. Is possible use MPI functions in postgreSQL source code? To do this the proper way

[HACKERS] MPI programming in postgreSQL backend source code

2011-11-09 Thread Rudyar Cortés
Hello, I'm a new programmer in postgreSQL source code.. Is possible use MPI functions in postgreSQL source code? Help me please! Best Regards. Rudyar. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresq