pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL overall design
10+ messages / 6 participants
[nested] [flat]
* PostgreSQL overall design
@ 2005-09-27 09:50 Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Re: PostgreSQL overall design Abhijit Menon-Sen <ams@toroid.org>
2005-09-27 13:08 ` Re: PostgreSQL overall design Andrew Dunstan <andrew@dunslane.net>
2005-09-27 14:12 ` Re: [PERFORM] PostgreSQL overall design Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 3 replies; 10+ messages in thread
From: Gnanavel S @ 2005-09-27 09:50 UTC (permalink / raw)
To: pgsql-performance; pgsql-hackers@postgresql.org
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 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 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) != 0)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not create directory \"%s\": %m", todir)));
xldir = AllocateDir(fromdir);
if (xldir == NULL)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not open directory \"%s\": %m", fromdir)));
--
with thanks & regards,
S.Gnanavel
Satyam Computer Services Ltd.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
@ 2005-09-27 10:27 ` Abhijit Menon-Sen <ams@toroid.org>
2005-09-27 12:05 ` Re: PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 13:00 ` Re: PostgreSQL overall design Jonah H. Harris <jonah.harris@gmail.com>
2 siblings, 2 replies; 10+ messages in thread
From: Abhijit Menon-Sen @ 2005-09-27 10:27 UTC (permalink / raw)
To: Gnanavel S <s.gnanavel@gmail.com>; +Cc: pgsql-performance; pgsql-hackers@postgresql.org
At 2005-09-27 15:20:05 +0530, s.gnanavel@gmail.com wrote:
>
> Can anyone please tell/point me where I can get the postgresql system
> layout (I've an interest to contribute).
http://www.postgresql.org/developer/coding
And, in particular:
http://www.postgresql.org/docs/faqs.FAQ_DEV.html
-- ams
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Re: PostgreSQL overall design Abhijit Menon-Sen <ams@toroid.org>
@ 2005-09-27 12:05 ` Gnanavel S <s.gnanavel@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Gnanavel S @ 2005-09-27 12:05 UTC (permalink / raw)
To: Abhijit Menon-Sen <ams@toroid.org>; +Cc: pgsql-performance
On 9/27/05, Abhijit Menon-Sen <ams@toroid.org> wrote:
>
> At 2005-09-27 15:20:05 +0530, s.gnanavel@gmail.com wrote:
> >
> > Can anyone please tell/point me where I can get the postgresql system
> > layout (I've an interest to contribute).
>
> http://www.postgresql.org/developer/coding
>
> And, in particular:
>
> http://www.postgresql.org/docs/faqs.FAQ_DEV.html
>
> -- ams
>
Thanks. I'll go thru' the documentation.
--
with regards,
S.Gnanavel
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Re: PostgreSQL overall design Abhijit Menon-Sen <ams@toroid.org>
@ 2005-09-27 13:00 ` Jonah H. Harris <jonah.harris@gmail.com>
2005-09-27 13:30 ` Re: PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
1 sibling, 1 reply; 10+ messages in thread
From: Jonah H. Harris @ 2005-09-27 13:00 UTC (permalink / raw)
To: Abhijit Menon-Sen <ams@toroid.org>; +Cc: Gnanavel S <s.gnanavel@gmail.com>; pgsql-hackers@postgresql.org
Were you looking for a call graph?
On 9/27/05, Abhijit Menon-Sen <ams@toroid.org> wrote:
>
> At 2005-09-27 15:20:05 +0530, s.gnanavel@gmail.com wrote:
> >
> > Can anyone please tell/point me where I can get the postgresql system
> > layout (I've an interest to contribute).
>
> http://www.postgresql.org/developer/coding
>
> And, in particular:
>
> http://www.postgresql.org/docs/faqs.FAQ_DEV.html
>
> -- ams
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Respectfully,
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
http://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Re: PostgreSQL overall design Abhijit Menon-Sen <ams@toroid.org>
2005-09-27 13:00 ` Re: PostgreSQL overall design Jonah H. Harris <jonah.harris@gmail.com>
@ 2005-09-27 13:30 ` Gnanavel S <s.gnanavel@gmail.com>
2005-09-30 23:19 ` Re: PostgreSQL overall design Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 10+ messages in thread
From: Gnanavel S @ 2005-09-27 13:30 UTC (permalink / raw)
To: Jonah H. Harris <jonah.harris@gmail.com>; +Cc: pgsql-hackers@postgresql.org
On 9/27/05, Jonah H. Harris <jonah.harris@gmail.com> wrote:
>
> Were you looking for a call graph?
Yes. I want to know the list and sequence of files involved during a call.
On 9/27/05, Abhijit Menon-Sen <ams@toroid.org> wrote:
> >
> > At 2005-09-27 15:20:05 +0530, s.gnanavel@gmail.com wrote:
> > >
> > > Can anyone please tell/point me where I can get the postgresql system
> > > layout (I've an interest to contribute).
> >
> > http://www.postgresql.org/developer/coding
> >
> > And, in particular:
> >
> > http://www.postgresql.org/docs/faqs.FAQ_DEV.html
> >
> > -- ams
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
>
>
> --
> Respectfully,
>
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> http://www.enterprisedb.com/
>
--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Re: PostgreSQL overall design Abhijit Menon-Sen <ams@toroid.org>
2005-09-27 13:00 ` Re: PostgreSQL overall design Jonah H. Harris <jonah.harris@gmail.com>
2005-09-27 13:30 ` Re: PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
@ 2005-09-30 23:19 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 10+ messages in thread
From: Jim C. Nasby @ 2005-09-30 23:19 UTC (permalink / raw)
To: Gnanavel S <s.gnanavel@gmail.com>; +Cc: Jonah H. Harris <jonah.harris@gmail.com>; pgsql-hackers@postgresql.org
On Tue, Sep 27, 2005 at 07:00:14PM +0530, Gnanavel S wrote:
> On 9/27/05, Jonah H. Harris <jonah.harris@gmail.com> wrote:
> >
> > Were you looking for a call graph?
>
>
> Yes. I want to know the list and sequence of files involved during a call.
Total non-coder question, but is there an open-source utility that's
capable of generating that? Seems like a useful piece of documentation
to have. Also seems like it'd be completely impractical to maintain by
hand.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
@ 2005-09-27 13:08 ` Andrew Dunstan <andrew@dunslane.net>
2005-09-27 13:46 ` Re: PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2 siblings, 1 reply; 10+ messages in thread
From: Andrew Dunstan @ 2005-09-27 13:08 UTC (permalink / raw)
To: Gnanavel S <s.gnanavel@gmail.com>; +Cc: pgsql-hackers@postgresql.org
[ -performance removed ]
Gnanavel S wrote:
>
> 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?
>
>
Under what circumstances do you imagine this will happen, since the
postmaster user owns all the files and directories?
cheers
andrew
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 13:08 ` Re: PostgreSQL overall design Andrew Dunstan <andrew@dunslane.net>
@ 2005-09-27 13:46 ` Gnanavel S <s.gnanavel@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Gnanavel S @ 2005-09-27 13:46 UTC (permalink / raw)
To: Andrew Dunstan <andrew@dunslane.net>; +Cc: pgsql-hackers@postgresql.org
On 9/27/05, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> [ -performance removed ]
>
> Gnanavel S wrote:
>
> >
> > 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?
> >
> >
>
>
> Under what circumstances do you imagine this will happen, since the
> postmaster user owns all the files and directories?
Understood. But can you explain why it is done in that way as what I said
seems to be standard way of doing it (correct me if I'm wrong).
--
with regards,
S.Gnanavel
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [PERFORM] PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
@ 2005-09-27 14:12 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-09-27 14:20 ` Re: [PERFORM] PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2 siblings, 1 reply; 10+ messages in thread
From: Bruce Momjian @ 2005-09-27 14:12 UTC (permalink / raw)
To: Gnanavel S <s.gnanavel@gmail.com>; +Cc: pgsql-performance; pgsql-hackers@postgresql.org
Have you read the developers FAQ?
---------------------------------------------------------------------------
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 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 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) != 0)
> ereport(ERROR,
> (errcode_for_file_access(),
> errmsg("could not create directory \"%s\": %m", todir)));
>
> xldir = AllocateDir(fromdir);
> if (xldir == 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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [PERFORM] PostgreSQL overall design
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 14:12 ` Re: [PERFORM] PostgreSQL overall design Bruce Momjian <pgman@candle.pha.pa.us>
@ 2005-09-27 14:20 ` Gnanavel S <s.gnanavel@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Gnanavel S @ 2005-09-27 14:20 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-performance; pgsql-hackers@postgresql.org
On 9/27/05, Bruce Momjian <pgman@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/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 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
> 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) != 0)
> > ereport(ERROR,
> > (errcode_for_file_access(),
> > errmsg("could not create directory \"%s\": %m", todir)));
> >
> > xldir = AllocateDir(fromdir);
> > if (xldir == 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
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2005-09-30 23:19 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-27 09:50 PostgreSQL overall design Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 10:27 ` Abhijit Menon-Sen <ams@toroid.org>
2005-09-27 12:05 ` Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 13:00 ` Jonah H. Harris <jonah.harris@gmail.com>
2005-09-27 13:30 ` Gnanavel S <s.gnanavel@gmail.com>
2005-09-30 23:19 ` Jim C. Nasby <jnasby@pervasive.com>
2005-09-27 13:08 ` Andrew Dunstan <andrew@dunslane.net>
2005-09-27 13:46 ` Gnanavel S <s.gnanavel@gmail.com>
2005-09-27 14:12 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-09-27 14:20 ` Gnanavel S <s.gnanavel@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox