Re: Is my Internet connection slow

Lists: pgsql-hackers
From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Is my Internet connection slow
Date: 2002-11-03 18:31:36
Message-ID: 200211031831.gA3IVab28160@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I have been serving my email/web/ftp using a 56k modem for the past two
months at candle.pha.pa.us (which is also momjian.postgresql.org). Are
people finding it slow? I am going to be getting a higher speed
connection and I need to know so I can choose the proper upgrade speed.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 02:07:06
Message-ID: 25370.1036375626@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I have been serving my email/web/ftp using a 56k modem for the past two
> months at candle.pha.pa.us (which is also momjian.postgresql.org). Are
> people finding it slow?

Yeah. I don't use your docs build anymore unless I really have to...
the one at hub.org is much more responsive.

regards, tom lane


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 02:37:27
Message-ID: 200211040237.gA42bRs04235@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I have been serving my email/web/ftp using a 56k modem for the past two
> > months at candle.pha.pa.us (which is also momjian.postgresql.org). Are
> > people finding it slow?
>
> Yeah. I don't use your docs build anymore unless I really have to...
> the one at hub.org is much more responsive.

Oh, that is a problem. Thanks.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 19:27:51
Message-ID: Pine.LNX.4.44.0211042027330.1395-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Bruce Momjian writes:

> > Yeah. I don't use your docs build anymore unless I really have to...
> > the one at hub.org is much more responsive.
>
> Oh, that is a problem. Thanks.

Why do we have two doc builds anyway?

--
Peter Eisentraut peter_e(at)gmx(dot)net


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 19:30:10
Message-ID: 29733.1036438210@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Why do we have two doc builds anyway?

Mainly because Bruce is willing to expend the cycles to rebuild his
nearly on-demand. Last I checked, the build on hub is only updated
once or twice a day, so it's not as useful for verifying doc checkins.

regards, tom lane


From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 20:25:10
Message-ID: 20021104162410.W91541-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 4 Nov 2002, Tom Lane wrote:

> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Why do we have two doc builds anyway?
>
> Mainly because Bruce is willing to expend the cycles to rebuild his
> nearly on-demand. Last I checked, the build on hub is only updated
> once or twice a day, so it's not as useful for verifying doc checkins.

'k, is there a reason why it can't be run more often? What command on hub
has to be run?


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 20:40:04
Message-ID: 989.1036442404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

"Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
>> Mainly because Bruce is willing to expend the cycles to rebuild his
>> nearly on-demand. Last I checked, the build on hub is only updated
>> once or twice a day, so it's not as useful for verifying doc checkins.

> 'k, is there a reason why it can't be run more often? What command on hub
> has to be run?

AFAICT, Bruce does a "cvs update" every ten or fifteen minutes and then
rebuilds the docs if anything changed in the doc subtree. Bruce, maybe
you could send Marc the script you use?

regards, tom lane


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-04 21:49:02
Message-ID: 200211042149.gA4Ln2x14750@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Sure, script attached. It uses a few of my other scripts so it will
need customization. I can easily supply those missing scripts too.
I run it every 7 minutes from cron with:

*/7 * * * * root /letc/pgsgml >/dev/null 2>&1

I can even install the whole thing on postgresql.org if you wish. It
requires a personal crontab, of course, and a directory to put the
result. I already have a ~momjian web directory for such stuff.

---------------------------------------------------------------------------

Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
> >> Mainly because Bruce is willing to expend the cycles to rebuild his
> >> nearly on-demand. Last I checked, the build on hub is only updated
> >> once or twice a day, so it's not as useful for verifying doc checkins.
>
> > 'k, is there a reason why it can't be run more often? What command on hub
> > has to be run?
>
> AFAICT, Bruce does a "cvs update" every ten or fifteen minutes and then
> rebuilds the docs if anything changed in the doc subtree. Bruce, maybe
> you could send Marc the script you use?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Attachment Content-Type Size
unknown_filename text/plain 1.9 KB

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 02:40:02
Message-ID: 20021104223809.U91541-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 4 Nov 2002, Bruce Momjian wrote:

>
> Sure, script attached. It uses a few of my other scripts so it will
> need customization. I can easily supply those missing scripts too.
> I run it every 7 minutes from cron with:
>
> */7 * * * * root /letc/pgsgml >/dev/null 2>&1
>
> I can even install the whole thing on postgresql.org if you wish. It
> requires a personal crontab, of course, and a directory to put the
> result. I already have a ~momjian web directory for such stuff.

Actually, from my read through the docs on CVS itself, there is a way of
setting it up so that when something is committed, it runs an external
program ... I'll have to do some further research on it, but I should be
able to set it up so that when someone commits something to docs, it does
the build ...

Can you setup your scripts on postgresql.org, and let me know where/what
to run, and I'll see if I can get that setup?


From: Rod Taylor <rbt(at)rbt(dot)ca>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 03:51:31
Message-ID: 1036468292.66684.55.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 2002-11-04 at 21:40, Marc G. Fournier wrote:
> On Mon, 4 Nov 2002, Bruce Momjian wrote:
>
> >
> > Sure, script attached. It uses a few of my other scripts so it will
> > need customization. I can easily supply those missing scripts too.
> > I run it every 7 minutes from cron with:
> >
> > */7 * * * * root /letc/pgsgml >/dev/null 2>&1
> >
> > I can even install the whole thing on postgresql.org if you wish. It
> > requires a personal crontab, of course, and a directory to put the
> > result. I already have a ~momjian web directory for such stuff.
>
> Actually, from my read through the docs on CVS itself, there is a way of
> setting it up so that when something is committed, it runs an external

One way is to change the DEFAULT in CVSROOT/loginfo. Normally its a log
accumulator or email system of somekind. But there is no reason it
couldn't be more complex and kick off additional jobs.

Just make sure whatever it is execs a background jobs (commits are held
during execution of the script) and protect against simultaneous runs of
the background job.

Rod Taylor


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 10:55:27
Message-ID: 8959.1036493727@www31.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> 'k, is there a reason why it can't be run more often?

If you say it's OK then no. I've made it run every 15 minutes now.

--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 16:05:30
Message-ID: 200211051605.gA5G5Ue25120@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Peter Eisentraut wrote:
> > 'k, is there a reason why it can't be run more often?
>
> If you say it's OK then no. I've made it run every 15 minutes now.

Will it run unconditionally or only on a CVS SGML change?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 16:07:25
Message-ID: 200211051607.gA5G7Pp25382@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I have ordered 128k ISDN, to be installed on November 12th. I am too
far for ADSL but I hope the distances will increase in the future.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 17:05:18
Message-ID: 20021105130339.K91541-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, 5 Nov 2002, Peter Eisentraut wrote:

> > 'k, is there a reason why it can't be run more often?
>
> If you say it's OK then no. I've made it run every 15 minutes now.

Is there any way of making it conditional on a change? I'm not sure how
the script is working, but if it involves doing a 'cvs update', if you
added in a check to see if anything got updated and generate if so, then
there is no reason why it couldn't be run every 5 minutes ...


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 18:13:31
Message-ID: Pine.LNX.4.44.0211051912350.1815-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Bruce Momjian writes:

> > > 'k, is there a reason why it can't be run more often?
> >
> > If you say it's OK then no. I've made it run every 15 minutes now.
>
> Will it run unconditionally or only on a CVS SGML change?

It will run when anything in CVS changes, which is something yours appears
to get wrong, because it still thinks it's 7.3devel.

--
Peter Eisentraut peter_e(at)gmx(dot)net


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 18:47:57
Message-ID: 200211051847.gA5IlvC19784@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > > > 'k, is there a reason why it can't be run more often?
> > >
> > > If you say it's OK then no. I've made it run every 15 minutes now.
> >
> > Will it run unconditionally or only on a CVS SGML change?
>
> It will run when anything in CVS changes, which is something yours appears
> to get wrong, because it still thinks it's 7.3devel.

It should only run when src/sgml changes, not any CVS change. And, why
do you think mine looks at 7.3devel?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is my Internet connection slow
Date: 2002-11-05 18:50:33
Message-ID: 200211051850.gA5IoXv20204@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Bruce Momjian writes:
> >
> > > > > 'k, is there a reason why it can't be run more often?
> > > >
> > > > If you say it's OK then no. I've made it run every 15 minutes now.
> > >
> > > Will it run unconditionally or only on a CVS SGML change?
> >
> > It will run when anything in CVS changes, which is something yours appears
> > to get wrong, because it still thinks it's 7.3devel.
>
> It should only run when src/sgml changes, not any CVS change. And, why
> do you think mine looks at 7.3devel?

OK, I figured out why it thought it was 7.3devel. I don't update
configure as part of the update, just doc/src/sgml. Updated now.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073