X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 31311D9933 for ; Tue, 27 Sep 2005 11:20:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97867-05 for ; Tue, 27 Sep 2005 14:20:33 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by svr1.postgresql.org (Postfix) with ESMTP id C8C10D992A for ; Tue, 27 Sep 2005 11:20:31 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 40so664138nzk for ; Tue, 27 Sep 2005 07:20:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HmUJjNPpp3XGHZr1KpVE7XkbfE5I23l5Mkei2Dwzpdxv7UZOiAwenN8FHBtfp9LQMOiOzc29yYr61Om5Vm6ACTOIq0hoYbKyhwiVmjQLEdsnRZeTU0slTitOuPaTNbidY4K/k2RqNqlV+LDfp15fz1UgZV6AKk45aiQNNTNw51c= Received: by 10.36.41.3 with SMTP id o3mr2301997nzo; Tue, 27 Sep 2005 07:20:35 -0700 (PDT) Received: by 10.36.120.14 with HTTP; Tue, 27 Sep 2005 07:20:35 -0700 (PDT) Message-ID: Date: Tue, 27 Sep 2005 19:50:35 +0530 From: Gnanavel S Reply-To: Gnanavel S To: Bruce Momjian Subject: Re: [PERFORM] PostgreSQL overall design Cc: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org In-Reply-To: <200509271412.j8REC8u04704@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1572_2849482.1127830835209" References: <200509271412.j8REC8u04704@candle.pha.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.268 required=5 tests=[AWL=0.157, HTML_40_50=0.086, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/1285 X-Sequence-Number: 73682 ------=_Part_1572_2849482.1127830835209 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/27/05, Bruce Momjian wrote: > > > Have you read the developers FAQ? Thanks Bruce. I'm going through that. --------------------------------------------------------------------------- > > Gnanavel S wrote: > > Hi All, > > > > Can anyone please tell/point me where I can get the postgresql system > layout > > (I've an interest to contribute). I would also like to know the files > > involved for performing each task ( for eg when doing a select operatio= n > > what is exactly happening in postgres along with the files). > > > > I was wandering inside the source for a while and I couldn't get a star= t > > point to go with. > > > > Need a clarification in copydir.c file of src/port directory, In the > > following snippet the destination directory is created first then the > source > > directory is read. Suppose if I don't have permission to read the > source, > > even then the destination directory would be created. > > I just want to know whether there is any reason for doing so? > > > > if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) !=3D 0) > > ereport(ERROR, > > (errcode_for_file_access(), > > errmsg("could not create directory \"%s\": %m", todir))); > > > > xldir =3D AllocateDir(fromdir); > > if (xldir =3D=3D NULL) > > ereport(ERROR, > > (errcode_for_file_access(), > > errmsg("could not open directory \"%s\": %m", fromdir))); > > > > > > > > -- > > with thanks & regards, > > S.Gnanavel > > Satyam Computer Services Ltd. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > -- with regards, S.Gnanavel ------=_Part_1572_2849482.1127830835209 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 9/27/05, Bruce Momjian <pgm= an@candle.pha.pa.us> wrote:

Have you read the developers FAQ?

Thanks Bruce. I'm going through that.

-------= --------------------------------------------------------------------
Gnanavel S wrote:
> Hi All,
>
> Can anyone please tell/po= int me where I can get the postgresql system layout
> (I've an intere= st to contribute). I would also like to know the files
> involved for= performing each task ( for eg when doing a select operation
> what is exactly happening in postgres along with the files).
&g= t;
> I was wandering inside the source for a while and I couldn't get= a start
> point to go with.
>
> Need a clarification in= =20 copydir.c file of src/port directory, In the
> following snippet the = destination directory is created first then the source
> directory is= read. Suppose if I don't have permission to read the source,
> even = then the destination directory would be created.
> I just want to know whether there is any reason for doing so?
&= gt;
> if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) !=3D 0)
> e= report(ERROR,
> (errcode_for_file_access(),
> errmsg("coul= d not create directory \"%s\": %m", todir)));
>
> xldir =3D AllocateDir(fromdir);
> if (xldir =3D=3D N= ULL)
> ereport(ERROR,
> (errcode_for_file_access(),
> err= msg("could not open directory \"%s\": %m", fromdir)));<= br> >
>
>
> --
> with thanks & regards,
> = S.Gnanavel
> Satyam Computer Services Ltd.

--
  B= ruce Momjian           &n= bsp;            = ;|  http://candle.pha.pa.us
  pgman@candle.ph= a.pa.us          &nbs= p;    |  (610) 359-1001
  +  If your life is a h= ard drive,     |  13 Roberts Road
 &n= bsp;+  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



= --
with regards,
S.Gnanavel ------=_Part_1572_2849482.1127830835209--