Re: [HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-26 Thread Vaibhav Kaushal
On Wed, May 25, 2011 at 11:45 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: I think the command 'where' does the same. And the command showed something which looked like was part of evaluation...it got me confused. Anyways, thanks robert. I will check that too. I did not know the 'bt

Re: [HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-26 Thread Vaibhav Kaushal
, mysterious. And I thought I was beginning to understand computers. :) Whatever be the case, I will look more into it and ask again if I get into too much of trouble. Regards, Vaibhav On Fri, May 27, 2011 at 9:18 AM, Tom Lane t...@sss.pgh.pa.us wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com

[HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-25 Thread Vaibhav Kaushal
Hi, Query: = I am aware of the fact that Expression evaluator is used to filter tuples based on the qual. However, I think it is not the only purpose it serves. As I manipulated the ExecEvalVar in the executor, the queries started behaving abnormally (the comparison operators , , lost

Re: [HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-25 Thread Vaibhav Kaushal
@pavan - thanks a lot. Will try it when i go to desktop the next time. -- Sent from my Android On 25 May 2011 15:33, Pavan Deolasee pavan.deola...@gmail.com wrote: On Wed, May 25, 2011 at 3:22 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: I see that the target list to be scanned

Re: [HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-25 Thread Vaibhav Kaushal
But somehow the execevalvar is being called. When i changed the logic of its working to use slot_getattr instead of cute_datum_array for the first run / call, everything just worked! This would indicate surely that the function does get called at least once before being called by executor for

Re: [HACKERS] Expression Evaluator used for creating the plan tree / stmt ?

2011-05-25 Thread Vaibhav Kaushal
I think the command 'where' does the same. And the command showed something which looked like was part of evaluation...it got me confused. Anyways, thanks robert. I will check that too. I did not know the 'bt' command. -- Sent from my Android On 25 May 2011 23:02, Robert Haas

Re: [HACKERS] Foreign memory context read

2011-05-24 Thread Vaibhav Kaushal
, 2011-05-23 at 09:58 -0400, Tom Lane wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: My mind started wandering after that error. Now, actually, i was trying to do something like this: *last_result = palloc0(sizeof(Datum)); bool *isnnuull = true; *last_result = slot_getattr(slot

[HACKERS] Foreign memory context read

2011-05-23 Thread Vaibhav Kaushal
Hello, I made some code changes, compilation went fine but the database could not start with the message: LOG: server process (PID 17684) was terminated by signal 11: Segmentation fault I think this is because of memory allocation outside of any memory context. Is it possible to create some

Re: [HACKERS] Foreign memory context read

2011-05-23 Thread Vaibhav Kaushal
...@enterprisedb.com wrote: On 23.05.2011 13:44, Vaibhav Kaushal wrote: Hello, I made some code changes, compilation went fine but the database could not start with the message: LOG: server process (PID 17684) was terminated by signal 11: Segmentation fault I think this is because

Re: [HACKERS] Foreign memory context read

2011-05-23 Thread Vaibhav Kaushal
Thanks for the suggestion. I will look into that shortly and let you know. By the way i am on fedora 13. -- Sent from my Android On 23 May 2011 17:28, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Vaibhav Kaushal wrote: Do you think its the 'slot_getattr' causing the seg-fault? On many

Re: [HACKERS] Foreign memory context read

2011-05-23 Thread Vaibhav Kaushal
Oh...well... I messed it up! Thanks a lot for that. The problem I think is the bool pointer. Will check it soon. -- Sent from my Android On 23 May 2011 19:28, Tom Lane t...@sss.pgh.pa.us wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: My mind started wandering after that error. Now

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-29 Thread Vaibhav Kaushal
I tried all aggregates - min,max,sum,count and avg. all are working. What do you suggest now? On Fri, Apr 29, 2011 at 11:30 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: On Thu, Apr 28, 2011 at 4:21 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Thanks a lot. I

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-29 Thread Vaibhav Kaushal
submitting the patch. On Fri, Apr 29, 2011 at 3:22 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: I tried all aggregates - min,max,sum,count and avg. all are working. What do you suggest now? On Fri, Apr 29, 2011 at 11:30 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-29 Thread Vaibhav Kaushal
16:24, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 29.04.2011 13:19, Vaibhav Kaushal wrote: I have a small db which I am using to test it. Moreover I am new to the terms. What would you mean by 'regression'? make check -- Heikki Linnakangas EnterpriseDB http

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-28 Thread Vaibhav Kaushal
in the functions ExecAgg, ExecInitAgg and their minions to evaluate the aggregates. The ExecEvalAggref() merely retrieves the results of aggregation calculated during ExecAgg. On Tue, Apr 26, 2011 at 12:04 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Hello all, While examining

[HACKERS] What would AggrefExprState nodes' args contain?

2011-04-26 Thread Vaibhav Kaushal
Hello all, While examining the executor, I was wondering what the *args part of AggrefExprState nodes contain. I found that the Aggref (Expr)'s args list is a list of TargetEntry nodes. But the state node's args is initialized in ExecInitExpr as: astate-args = (List *) ExecInitExpr((Expr *)

Re: [HACKERS] How would sorting work with millions of rows in a huge DB with PG?

2011-04-10 Thread Vaibhav Kaushal
Thanks a lot for the help. Regards, Vaibhav On Sun, Apr 10, 2011 at 11:07 AM, to...@tuxteam.de wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Apr 10, 2011 at 05:20:02AM +0530, Vaibhav Kaushal wrote: Hello all, I was going through some papers related to sorting and since

[HACKERS] How would sorting work with millions of rows in a huge DB with PG?

2011-04-09 Thread Vaibhav Kaushal
Hello all, I was going through some papers related to sorting and since I am studying PG code side by side, I wondered how sorting would be done on a DB with millions of rows on disk with GBs of data. Since holding everything in memory would not be the possible solution, how do we actually sort

[HACKERS] ExecEvalVar does not have appropriate ExprState?

2011-03-28 Thread Vaibhav Kaushal
Hi, I see the ExecInitExpr says something like this: case T_Var: state = (ExprState *) makeNode(ExprState); state-evalfunc = ExecEvalVar; --- But the ExecEvalVar function definition says: Var*variable = (Var *)

Re: [HACKERS] ExecEvalVar does not have appropriate ExprState?

2011-03-28 Thread Vaibhav Kaushal
) Regards, Vaibhav On Mon, Mar 28, 2011 at 1:05 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 28.03.2011 10:02, Vaibhav Kaushal wrote: Hi, I see the ExecInitExpr says something like this: case T_Var: state = (ExprState *) makeNode(ExprState

Re: [HACKERS] When and how many times does ExecSetParamPlan executes?

2011-03-26 Thread Vaibhav Kaushal
your last reply again and again). Thank you again. Regards, Vaibhav On Fri, 2011-03-25 at 15:59 -0400, Tom Lane wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: So, I think that the function ExecSetParamPlan (as the code suggests too) is called _once_ in any plan/expression

[HACKERS] When and how many times does ExecSetParamPlan executes?

2011-03-25 Thread Vaibhav Kaushal
Hello all, I was going through the Expression Evaluator and was trying to understand how the expressions are formed and evaluated. I was informed on the IRC channel that the PARAM nodes are quite important and many well written client applications use PARAMs for sending query to the backend. I

Re: [HACKERS] When and how many times does ExecSetParamPlan executes?

2011-03-25 Thread Vaibhav Kaushal
I could run on psql is that I am using gdb to debug (and notice the steps taken by) PG. Regards, Vaibhav On Fri, 2011-03-25 at 14:37 -0400, Tom Lane wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: Hello all, I was going through the Expression Evaluator and was trying

[HACKERS] How to look at the Expression Trees

2011-03-21 Thread Vaibhav Kaushal
Hi all, I have been trying to work on the expression evaluator (trying to alter it just for the seqscan case). I have understood a few things. I wish someone could tell me if I am wrong at some point. As far as I have gone through the code, I think: 1. Quals are formulated by planner 2. Quals

Re: [HACKERS] How to look at the Expression Trees

2011-03-21 Thread Vaibhav Kaushal
On Mon, Mar 21, 2011 at 5:47 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Yes. There's actually two trees involved. The planner produces a tree of Expr nodes, and ExecInitExpr prepares a tree of ExprState nodes that mirrors the first tree. The ExprStates contain run-time

Re: [HACKERS] How to look at the Expression Trees

2011-03-21 Thread Vaibhav Kaushal
Hi, You said: ExecMakeFunctionResultNoSets is used to evaluate function calls. What are the 'functions' there? Are they the user supplied pl/PGSQL style user functions, the functions handled by fmgr or are they just another C function which make the Expression Evaluator? Regards, Vaibhav

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-18 Thread Vaibhav Kaushal
Hi, That was the question I was facing 5 months ago and trust me I am doing it even now. With an average of 6+ hours going into PostgreSQL Code, even with best practices (as suggested by the developers) I still think I know less than 10 percent. It is too huge to be swallowed at once. I too had

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-18 Thread Vaibhav Kaushal
but how much does it help when I am already banging my head into source since last 5 months? Regards, Vaibhav On Fri, 2011-03-18 at 22:44 +0800, hom wrote: 2011/3/18 Vaibhav Kaushal vaibhavkaushal...@gmail.com: Hi, That was the question I was facing 5 months ago and trust me I am doing

[HACKERS] Where the Quals are actually 'List'ed

2011-02-07 Thread Vaibhav Kaushal
Hi, I find that ExecInitExpr creates a ExprState tree (and so say the comments above the function in the source). Also, it seems to decide which function would get called when the expression is to be evaluated when ExecQual runs, by setting the function pointer, for example:

Re: [HACKERS] Where the Quals are actually 'List'ed

2011-02-07 Thread Vaibhav Kaushal
On Mon, 2011-02-07 at 11:16 -0500, Tom Lane wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: Hi, I find that ExecInitExpr creates a ExprState tree (and so say the comments above the function in the source). Also, it seems to decide which function would get called when

[HACKERS] Apologizing about the ELEPHANTS email.

2011-02-02 Thread Vaibhav Kaushal
Hello all, I am sorry for sending an email about elephants to the hackers list. It was accidental. This mailing list is the only mailing list which I am subscribed to. Most others are on a different email address. Actually I was using some website which said that it was trying to save trees and

Re: [HACKERS] Anyone for SSDs?

2010-12-11 Thread Vaibhav Kaushal
On Fri, 2010-12-10 at 18:07 -0800, Josh Berkus wrote: On 12/10/10 5:06 PM, Daniel Loureiro wrote: An quicksort method in sequential disk its just awful to be thinking in a non SSD world, but its possible in an SSD. So, code it. Shouldn't be hard to write a demo comparison. I don't

Re: [HACKERS] Anyone for SSDs?

2010-12-10 Thread Vaibhav Kaushal
On Fri, 2010-12-10 at 07:38 -0500, Robert Haas wrote: On Fri, Dec 10, 2010 at 1:39 AM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Most of you already know I am new to this list and newer to any OSS development. However, while browsing the source code (of 9.0.1) I find

Re: [HACKERS] Anyone for SSDs?

2010-12-10 Thread Vaibhav Kaushal
On Fri, 2010-12-10 at 18:07 -0800, Josh Berkus wrote: On 12/10/10 5:06 PM, Daniel Loureiro wrote: An quicksort method in sequential disk its just awful to be thinking in a non SSD world, but its possible in an SSD. So, code it. Shouldn't be hard to write a demo comparison. I don't

Re: [HACKERS] Anyone for SSDs?

2010-12-10 Thread Vaibhav Kaushal
On Fri, 2010-12-10 at 23:19 -0500, Stephen Frost wrote: * Vaibhav Kaushal (vaibhavkaushal...@gmail.com) wrote: I would like to do that (coding), but I do not have a SSD on my machine! :( Would it be impractical to try it for me? Again I do not know how to test PG :( No, it's

[HACKERS] Anyone for SSDs?

2010-12-09 Thread Vaibhav Kaushal
Hi all, Most of you already know I am new to this list and newer to any OSS development. However, while browsing the source code (of 9.0.1) I find that there is only one way to store relations on disk - the magnetic disk. This came suddenly in my mind so I am asking the experts here.

Re: [HACKERS] Requirement for the Buffer manager to load multiple pages at once

2010-12-04 Thread Vaibhav Kaushal
Thank you Kevin. I am going to look into it. I still have to learn a lot :) Regards, Vaibhav On 12/4/10, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Vaibhav Kaushal wrote: I want to parallelize the search / scan (specifically hash) by using multiple cores in the processors today

[HACKERS] Requirement for the Buffer manager to load multiple pages at once

2010-12-03 Thread Vaibhav Kaushal
Hi all, I have gone through the code a bit more this time and I think that what I originally thought of as a task of executor in the beginning (as I read the documentation) seems to be split at multiple points. So i am asking a question based on what I have understood so far. Keeping it a bit

Re: [HACKERS] Proposal: First step towards Intelligent, integrateddatabase

2010-12-02 Thread Vaibhav Kaushal
I know world's population. Non of the person thinks alike and still many peoples goal can be the same. Nothing is virgin in this world. If someone thinks like that then it is a mistake. My aim is to prove that Postgresql can be the great leader if we put natural intelligence in database which is

Re: [HACKERS] Fwd: What do these terms mean in the SOURCE CODE?

2010-11-21 Thread Vaibhav Kaushal
Thanks for that informative article. :) Taught me a few new points about Eclipse :) On Sun, Nov 21, 2010 at 2:29 PM, Leonardo Francalanci m_li...@yahoo.itwrote: Here's my single biggest tip for newcomers to the Postgres source: if you don't use ctags, glimpse, or some other tool that can

Re: [HACKERS] Fwd: What do these terms mean in the SOURCE CODE?

2010-11-20 Thread Vaibhav Kaushal
19, 2010 at 10:51 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Is no one ready to help on this? :( Apparently, no one is ready to drop what they are doing to immediately answer your email before all the other ones they need to answer, but I wouldn't infer from that that no one

Re: [HACKERS] Fwd: What do these terms mean in the SOURCE CODE?

2010-11-20 Thread Vaibhav Kaushal
I sure do respect that. Appreciated. :) -Vaibhav (*_*) On Sun, Nov 21, 2010 at 12:33 AM, Robert Haas robertmh...@gmail.com wrote: On Sat, Nov 20, 2010 at 1:59 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Thanks a lot for the answer. I see a lot of people discussing so many things

Re: [HACKERS] Fwd: What do these terms mean in the SOURCE CODE?

2010-11-20 Thread Vaibhav Kaushal
Thanks for your concerns about my question. I am really happy to get the answers. @Mr. Tom Lane: Thanks for your explanation but I am already using Eclipse which gets me to the definitions real easy. I do not post my questions on the Hackers forum with any intention to disturb anyone. I just ask

[HACKERS] What do these terms mean in the SOURCE CODE?

2010-11-19 Thread Vaibhav Kaushal
I am going through the Executor code and come across the following terms quite often. Can someone tell me what do they mean (in a few (may be a couple of) sentences)? 1. Scan State 2. Plan State 3. Tuple Projection 4. EState 5. Qual 6. Expression They sound quite ambiguous in the source code,

[HACKERS] Fwd: What do these terms mean in the SOURCE CODE?

2010-11-19 Thread Vaibhav Kaushal
Is no one ready to help on this? :( -Vaibhav -- Forwarded message -- From: Vaibhav Kaushal vaibhavkaushal...@gmail.com Date: Fri, Nov 19, 2010 at 9:11 PM Subject: What do these terms mean in the SOURCE CODE? To: pgsql-hackers@postgresql.org I am going through the Executor code

[HACKERS] Which data structures for the index?

2010-11-18 Thread Vaibhav Kaushal
Hi all, I have a small problem: Suppose that I have a table in PostgreSQL which has a integer field as its Primary key and I have used the Hash indexing method for creating the index for the field on the table. Now I want to know the following details about the index (assuming the machine running

Re: [HACKERS] Which data structures for the index?

2010-11-18 Thread Vaibhav Kaushal
Thanks once again Mr. Heikki for your help. Got your point! Thanks :) -Vaibhav (*_*) On Thu, Nov 18, 2010 at 7:10 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 18.11.2010 15:19, Vaibhav Kaushal wrote: I have a small problem: Suppose that I have a table in PostgreSQL

Re: [HACKERS] Which file does the SELECT?

2010-11-10 Thread Vaibhav Kaushal
it on the list. Thanks anyways for the reply. -Vaibhav (*_*) On Wed, Nov 10, 2010 at 9:38 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, Nov 8, 2010 at 9:55 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: I have started with the work and am using Eclipse and it helps quite

Fwd: [HACKERS] Which file does the SELECT?

2010-11-08 Thread Vaibhav Kaushal
-- Forwarded message -- From: Vaibhav Kaushal vaibhavkaushal...@gmail.com Date: Tue, Nov 9, 2010 at 8:24 AM Subject: Re: [HACKERS] Which file does the SELECT? To: Dimitri Fontaine dimi...@2ndquadrant.fr I have started with the work and am using Eclipse and it helps quite a lot. I

Fwd: [HACKERS] Which file does the SELECT?

2010-11-08 Thread Vaibhav Kaushal
...@2ndquadrant.frwrote: David Fetter da...@fetter.org writes: On Mon, Oct 11, 2010 at 04:14:04PM +0530, Vaibhav Kaushal wrote: Is there something like that in Kdevelop? I dont use CLI editors much. KDevelop is listed as one of the editors that support ctags. I've just developed some code

[HACKERS] Can we talk about a version which has already been developed?

2010-11-03 Thread Vaibhav Kaushal
I read a few things about development in the open source area on different websites, had a talk with a few friends and thought that I cannot work on the development branch of postgres right now. So I have this one single question: Would I be able to get the answers if I asked questions about the

[HACKERS] Fwd: Starting off with the development

2010-11-02 Thread Vaibhav Kaushal
And I wanted to know what type of data structures are created by the parser / planner and how are they read by the executor. I know that it is some sort of tree. But how many child nodes are there in a node on the tree and what structure is the NODE itself of? Which files should I look into to

[HACKERS] Starting off with the development

2010-11-01 Thread Vaibhav Kaushal
Hello, I think that I want to get indulged in development. Have gone through the code a bit, Unable to understand so might need some help over there. I hope I will recieve help. What version should I start from? I guess postgresql 9.1 alpha would be good. Please suggest some other dev version

Re: [HACKERS] Which file does the SELECT?

2010-10-11 Thread Vaibhav Kaushal
Is there something like that in Kdevelop? I dont use CLI editors much. On Mon, Oct 11, 2010 at 7:55 AM, David Christensen da...@endpoint.comwrote: On Oct 10, 2010, at 12:21 PM, Vaibhav Kaushal wrote: Thanks to both hitoshi and tom for your replies. I think I need to look

[HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
I have gone through the source code a bit but I wanted to know that which file contains the code that performs the final SLECTION after the optimizer has created the final plan? I mean which part of the executor is responsible for the SELCT to be run? Can someone tell me the file which governs

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
Thanks for the reply. So if I am not wrong, I will have to understand the whole querying process in detail? If it is so, then where do I start from? -Vaibhav On Sun, Oct 10, 2010 at 1:41 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-10-10 at 13:32 +0530, Vaibhav Kaushal wrote: I

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
to be) the cheapest is chosen. Can someone tell me what are 'Join Pairs with no Join clause' ? I am not able to figure that out! -Vaibhav (*_*) On Sun, Oct 10, 2010 at 1:58 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: Thanks for the reply. So if I am not wrong, I will have to understand the whole

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
On Sun, Oct 10, 2010 at 9:29 PM, Tom Lane t...@sss.pgh.pa.us wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: Can someone tell me what are 'Join Pairs with no Join clause' ? I am not able to figure that out! Consider select * from t1, t2, t3 where t1.a = t2.x and t1.b = t3.y

[HACKERS] Postgres Licensing

2010-09-20 Thread Vaibhav Kaushal
May be this is the wrong place to ask the question. Still, answer me if someone can or please redirect me to some place where it can be answered. My questions are: 1. PostgreSQL can be distributed freely according to the license terms. Can it be sold (for a price) without changing anything in the

Re: [HACKERS] Postgres Licensing

2010-09-20 Thread Vaibhav Kaushal
at 11:58 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 20/09/10 09:48, Vaibhav Kaushal wrote: 1. PostgreSQL can be distributed freely according to the license terms. Can it be sold (for a price) without changing anything in the source? Yes. You will have a hard

[HACKERS] Introducing Myself

2010-09-16 Thread Vaibhav Kaushal
Hello all, May be this is notneeded, but I thought I could just introduce myself to the list and why am I here. My name is Vaibhav Kaushal, a good leaner and a really bad student. I bunk classes, don't attend exams and love to develop. I just completed my engineering course in Information

Re: [HACKERS] Introducing Myself

2010-09-16 Thread Vaibhav Kaushal
Thank you. They did actually help me much. :) On Thu, Sep 16, 2010 at 7:14 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: please show me the way, at least to the terms which you people use when developing. You should probably