[HACKERS] Implementing a join algorithm in Postgres

Hi, I have written a C program which reads from 3 files(Each file is table having 2 columns and thousands of rows).The program is used to join those 3 tables and the algorithm which I have written will work only for those 3 files. Now I want to test this program for postgres. Can someone tell me h

Re: [HACKERS] enabling nestedloop and disabling hashjon

# comment marker in the file's entry, Thank you. ᐧ On Fri, Feb 13, 2015 at 2:50 AM, David G Johnston < david.g.johns...@gmail.com> wrote: > Jim Nasby-5 wrote > > On 2/10/15 9:29 AM, Tom Lane wrote: > >> Ravi Kiran < > > > ravi.kolanpaka@ > > > &g

Re: [HACKERS] enabling nestedloop and disabling hashjon

get disabled when I changed it in the postgresql file. ᐧ On Fri, Feb 13, 2015 at 2:34 AM, Jim Nasby wrote: > On 2/10/15 9:29 AM, Tom Lane wrote: > >> Ravi Kiran writes: >> >>> yes sir, I did try the pg_ctl reload command, but its still using the >>> hash >

Re: [HACKERS] enabling nestedloop and disabling hashjon

yes sir, I did try the pg_ctl reload command, but its still using the hash join algorithm and not the nested loop algorithm. I even restarted the server, even then its still using the hash join algorithm Thanks ᐧ On Tue, Feb 10, 2015 at 5:28 AM, Tom Lane wrote: > Ravi Kiran writes: &g

[HACKERS] enabling nestedloop and disabling hashjon

Hi, I want to disable the hashjoin algorithm used by postgres by default, and enable the nested loop join algorithm, can some one tell me how to do that. I tried modifying the postgresql.conf file where I set the value enable_hashjoin=off and also enable_mergejoin=off, so that I could force post

[HACKERS] 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

[HACKERS] 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

Re: [HACKERS] attaching a process in eclipse

location.* is the error something related my OS or is it related to postgres. Thank you for telling the mistake, I will follow the things which you told from the next time. Thank you On Sun, Dec 28, 2014 at 7:36 PM, Craig Ringer wrote: > On 12/28/2014 07:49 PM, Ravi Kiran wrote: > > Th

[HACKERS] 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 https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_PostgreSQL_from_Eclips

[HACKERS] 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 fine.

[HACKERS] 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