[GENERAL] Hash function constant in the Hash join algorithm

Hi, As part part of my project, I had to compare the time taken by the Hashjoin algorithm to that of Nested loop algorithm for the inner join and Natural join queries, under two cases. I used six tables to join each other each containing 5000 rows each approximately. The two cases are given

[GENERAL] Error in the connection to the server

Hi, I have installed postgresql-9.4.0 version. I have started the server from eclipse indigo version using Run configurations. There is a table in my database whose name is b. whenever I give a query which is related to this table I get the error *The connection to the server was lost.

[GENERAL] Policy.c program

Hi, I am using the postgresql-9.4.0 version. There is a program policy.c which is there in the previous versions. The following link shows the program. http://doxygen.postgresql.org/policy_8c.html But in the version 9.4.0, I cannot find it. I want to know whether this program being removed

[GENERAL] Relation name stored in Postgres

Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name being stored. Thank you -- Regards, K.Ravikiran ᐧ

Re: [GENERAL] Relation name stored in Postgres

: Hi it is in system catalog - table pg_class, column relname Regards Pavel Stehule 2015-04-02 15:52 GMT+02:00 Ravi Kiran ravi.kolanp...@gmail.com: Hi, I want to know how the relation name is stored in postgres, In which part of the postgres source code could I find the relation name

Re: [GENERAL] Relation name stored in Postgres

Hi, Also, could you tell me during which stage(whether parser,optimizer or executor) does the table name gets stored, and if possible could you tell me which program specifically does that. ᐧ On Thu, Apr 2, 2015 at 7:56 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote: Hi, Thank you Sir. Also

[GENERAL] hash function in Postgres

hi, I want to know what kind of hash function postgresql uses while joining. I was debugging through gdb, I found out that it is not using bob jenkins hash function but a different hash function *hash_uint32() and hash_any() *functions if the joining attribute is an integer, and a different kind

[GENERAL] Hash Function

Hi, I want to know what kind of hash function postgres is using currently, can someone please explain the algorithm postgres is using for the hash function in the hash join algorithm. Thanks, K.Ravikiran

[GENERAL] NODE

hi, I am going through the hashjoin algorithm in postgres. I find a function ExecHashjoin , which is called each time a new tuple is required by the hash join *Node.* could someone explain what exactly node mean in postgres. Thanks

[GENERAL] attaching a process in eclipse

hi, I am working with postgresql 9.4.0 source using eclipse(indigo version) in ubuntu 14.04. I am facing a problem of attaching a client process to postgresql server. I am following the steps given in this link

[GENERAL] mysql with postgres

hi all, Is postgres source code compatible with mysql database?? If it is, could someone could give me some links so that I can do that. I want to hack into the postgres source code, but as I am comfortable with mysql, I want to use the mysql database not postgres. any references would be

[GENERAL] debugging with gdb

Hi, I am facing some problem with gdb for the past few days. I want to debug nestloop.c in postgresql , so I followed the below steps. I followed the steps given in the below for collecting the stack trace.

[GENERAL] gdb debugging with postgres

hi , I am trying to attach a postgres process to gdb, Since I am using only 1 client , I am using the script give by Tom Lane posted in the mailing list. http://www.postgresql.org/message-id/bd6a35510707221030p694cd515kfeb529078557b...@mail.gmail.com I started running the client by following

[GENERAL] debugging with gdb in postgres

hi, I am trying to learn how postgresql implements the join algorithms. So I am trying to learn about the source code of the executor precisely the file nodenestloop.c . In the executor file I have nodenestloop.o but no binary executor file. I am using helios eclipse to edit the source code.

[GENERAL] breakpoints in eclipse using postgresql

hi, I am using helios Eclipse for debugging my code in postgresql. My aim is to know how postgresql uses join algorithms during the join query, so I started to debug*nodenestloop.c* which is in the Executor folder. I gave break points in that file, But whenever I try to debug that file, the

[GENERAL] debugging with child process

hi, can any one help me with the 4th and 5th steps of the following link which is to debug with a child process in postgres. *https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes*

[GENERAL] Executing nodenestloop.c

hi, I am using the environment Eclipse for the execution of the programs in the executor, whenever I give break points to specific program in eclipse , the control goes to main.c and finally the process never comes back to the actual program. Is there any way that the process be constrained only

[GENERAL] eclipse-gdb

hi, How do we debug specific functions in gdb of eclipse. Whenever I give break points in nodenestloop.c, it goes to main.c and finally the process ends there, The control never comes back to nodenestloop, how can we the proces constrained only to nodenestloop. Thank you

[GENERAL] eclipse-postgres

hi, How to compile and run the files the source code of postgres in eclipse, how to compile a c program in the backend directory of postgres?? I followed the steps in https://wiki.postgresql.org/wiki/Working_with_Eclipse , but when I build the program nodeNestloop.c in the backend directory, I

[GENERAL] Postgress Doubts

Hello, I am Ravikiran, pursuing my third year BITS Pilani, India, I am doing my thesis in postgress technology, The project is about implementing new join algorithms in postgres, Since I am new to postgress, could you help me in which part of source code of postgres should be looking in postgress

[GENERAL] Multi Lingual problem

I am using the psqlodbc driver to connect to postgresql... But this is not supporting all the languages that UTF should support.. Database is of the correct encoding that is UTF... can you please give a solution so that i can psqlodbc supports multiple languages. Right now there is support for

[GENERAL] Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L

[GENERAL] Fwd: Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L

[GENERAL] Fwd: Returning Cursor

only got the cursor name. We've been trying to access the values for the past one week. Can you please help me by sending me a sample code as to how to get the values in a recordset using this refcursor. Please do reply. This is very urgent. Thanks and regards Ravi Kiran L