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 5E60CD9201
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Tue, 27 Sep 2005 06:50:11 -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 83568-09
	for <pgsql-hackers-postgresql.org@localhost.postgresql.org>;
	Tue, 27 Sep 2005 09:50:02 +0000 (GMT)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201])
	by svr1.postgresql.org (Postfix) with ESMTP id 734E0D98DB
	for <pgsql-hackers@postgresql.org>;
	Tue, 27 Sep 2005 06:50:02 -0300 (ADT)
Received: by zproxy.gmail.com with SMTP id q3so1652348nzb
	for <pgsql-hackers@postgresql.org>;
	Tue, 27 Sep 2005 02:50:05 -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:mime-version:content-type;
	b=TNRbmhtZUzXvN7XqxlxtE3HMmRE///Crd7K+CgtJH5NdWF/IJ/hyD2Jth8nOfnyHoOfeZCtbCqoQoukwowIRtfqFDCYOl/PLLOYvs+xvqTadW1vgc5BagE7Z/w4ZB82G8dECzqgMxsbVLLM4nA/DE0ujHUoVcJKkEN8zHGlV00U=
Received: by 10.36.82.20 with SMTP id f20mr2566465nzb;
	Tue, 27 Sep 2005 02:50:05 -0700 (PDT)
Received: by 10.36.120.14 with HTTP; Tue, 27 Sep 2005 02:50:05 -0700 (PDT)
Message-ID: <eec3b03c0509270250bc2fc97@mail.gmail.com>
Date: Tue, 27 Sep 2005 15:20:05 +0530
From: Gnanavel S <s.gnanavel@gmail.com>
Reply-To: Gnanavel S <s.gnanavel@gmail.com>
To: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org
Subject: PostgreSQL overall design
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_242_4124819.1127814605101"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.277 required=5 tests=[AWL=0.157, HTML_50_60=0.095,
	HTML_MESSAGE=0.001, RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200509/1222
X-Sequence-Number: 73619

------=_Part_242_4124819.1127814605101
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,

Can anyone please tell/point me where I can get the postgresql system layou=
t
(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 operation
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 start
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 sourc=
e
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.

------=_Part_242_4124819.1127814605101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,<br>
<br>
&nbsp; Can anyone please tell/point&nbsp; 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 operation what is exactly happening in postgres along
with the files).<br>
<br>
&nbsp; I was wandering inside the source for a while and I couldn't get a s=
tart point to go with. <br>
<br>
&nbsp;Need a clarification in copydir.c file of src/port
directory,&nbsp; 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.<br>
I just want to know whether there is any reason for doing so?<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (mkdir(todir, S_IRUSR | S_IWU=
SR | S_IXUSR) !=3D 0)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; ereport(ERROR,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(errcode_for_file_access(),<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
errmsg(&quot;could not create directory \&quot;%s\&quot;: %m&quot;, todir))=
);<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xldir =3D AllocateDir(fromdir);<=
br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (xldir =3D=3D NULL)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; ereport(ERROR,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(errcode_for_file_access(),<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
errmsg(&quot;could not open directory \&quot;%s\&quot;: %m&quot;, fromdir))=
);<br>
<br>
<br>
<br>-- <br>with thanks &amp; regards,<br>S.Gnanavel<br>Satyam Computer Serv=
ices Ltd.

------=_Part_242_4124819.1127814605101--