, 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 wrote:
> Vaibhav Kaushal writes:
> > Why do th
(and in no other program). I am on Fedora 13 X86_64.
Regards,
Vaibhav
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 evaluat
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" wrote:
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 qual
@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" wrote:
> On Wed, May 25, 2011 at 3:22 PM, Vaibhav Kaushal <
> vaibhavkaushal...@gmail.com> wrote:
>
>> I see that the target l
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 ef
n Mon, 2011-05-23 at 09:58 -0400, Tom Lane wrote:
> Vaibhav Kaushal 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;
> > *
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" wrote:
> Vaibhav Kaushal writes:
>> My mind started wandering after that error. Now, actually, i
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" wrote:
> Vaibhav Kaushal wrote:
>
>> Do you think its the 'slot_getattr' causing the seg-fault
, Heikki Linnakangas <
heikki.linnakan...@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 (P
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 va
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'?
>
> useful.
>
> Read http://wiki.postgresql.org/wiki/Submitting_a_Patch before 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 worki
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&
e used 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> w
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 *) agg
Thanks a lot for the help.
Regards,
Vaibhav
On Sun, Apr 10, 2011 at 11:07 AM, 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 rel
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 th
)
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:
>>
>>
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 *) e
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 writes:
> > So, I think that the function ExecSetParamPlan (as the code suggests
> > too) is called _once_ in any plan/expression and that s
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 writes:
> > Hello all,
> > I was going through the Expression Evaluator and was trying to
> &g
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 fo
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
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 r
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 are
written by the devs 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 :
> > Hi,
> > That was the question I was facing 5 months ago and trust me
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 t
On Mon, 2011-02-07 at 11:16 -0500, Tom Lane wrote:
> Vaibhav Kaushal 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 w
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:
bstate->xprstate.eva
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
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 d
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
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 do
On Fri, 2010-12-10 at 07:38 -0500, Robert Haas wrote:
> On Fri, Dec 10, 2010 at 1:39 AM, Vaibhav Kaushal
> 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
> > that
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.
Considerin
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 wrote:
> Vaibhav Kaushal wrote:
>
>> I want to parallelize the search / scan (specifically hash) by
>> using multiple cores in the processors today.
>
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 orga
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 m
Thanks for that informative article. :) Taught me a few new points about
Eclipse :)
On Sun, Nov 21, 2010 at 2:29 PM, Leonardo Francalanci wrote:
> > 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 quickly
> > sh
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 f
I sure do respect that. Appreciated. :)
-Vaibhav (*_*)
On Sun, Nov 21, 2010 at 12:33 AM, Robert Haas wrote:
> On Sat, Nov 20, 2010 at 1:59 PM, Vaibhav Kaushal
> wrote:
> > Thanks a lot for the answer. I see a lot of people discussing so many
> things
> > so I thought my
:51 PM, Vaibhav Kaushal
> 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 wants to
Is no one ready to help on this? :(
-Vaibhav
-- Forwarded message --
From: Vaibhav Kaushal
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 and come across the
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, spe
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
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
it on the list.
Thanks anyways for the reply.
-Vaibhav (*_*)
On Wed, Nov 10, 2010 at 9:38 AM, Robert Haas wrote:
> On Mon, Nov 8, 2010 at 9:55 PM, Vaibhav Kaushal
> wrote:
> > I have started with the work and am using Eclipse and it helps quite a
> lot.
> > I can find t
vid Fetter 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 develop
-- Forwarded message --
From: Vaibhav Kaushal
Date: Tue, Nov 9, 2010 at 8:24 AM
Subject: Re: [HACKERS] Which file does the SELECT?
To: Dimitri Fontaine
I have started with the work and am using Eclipse and it helps quite a lot.
I can find the declarations quite easily. Thanks
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
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 ge
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 (i
Is there something like that in Kdevelop? I dont use CLI editors much.
On Mon, Oct 11, 2010 at 7:55 AM, David Christensen wrote:
>
> 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
lies.
-Vaibhav
On Sun, Oct 10, 2010 at 9:29 PM, Tom Lane wrote:
> Vaibhav Kaushal 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 =
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 wi
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 wrote:
> On sön, 2010-10-10 at 13:32 +0530, Vaibhav Kaushal wrote:
> > I
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 it?
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 t
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
Thank you. They did actually help me much. :)
On Thu, Sep 16, 2010 at 7:14 PM, Kevin Grittner wrote:
> Vaibhav Kaushal wrote:
>
> > please show me the way, at least to the terms which you people
> > use when developing.
>
> You should probably start with this pa
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 Inform
62 matches
Mail list logo
