Skip site navigation (1) Skip section navigation (2)

Re: Archives too slow

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: Archives too slow
Date: 2004-08-29 19:24:49
Message-ID: Pine.GSO.4.58.0408292316040.5201@ra.sai.msu.su (view raw or flat)
Thread:
Lists: pgsql-www
I always didn't understand why not have static pages for mailing list
archive if they already generated.

Another thing to consider is using
lightweight frontend with ability to cache pages generated by heavy backend.
www.pgsql.ru uses 3-servers setup - frontend (apache+mod_accel),
backend ( apache + modperl ) and thttpd (very light and fast) for serving
binary data (images, for example). Only frontend interacts with user, so slow
clients (bad connectivity) don't bother heavy backend and, consequently,
db server.


	Oleg
On Sun, 29 Aug 2004, Greg Sabino Mullane wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> > I'm going to look at mirroring it onto the same server that runs
> > ftp.postgresql.org ... archives is the worst site that we run, since its
> > all a bunch of little flat files, so when it gets indexed by the various
> > search engines, disk I/O goes through the roof ... we had googlebot index
> > it once where we had to literally shut down the server for a few minutes
> > while we waited for load to drop ...
>
> On googlebot's page[1], they claim they never go more than once every few
> seconds. Surely this should not be a problem as long as these are static
> pages. They also have an email address on that page where you can request
> that Google go a little gentler on your site.
>
> Also, if the pages are static (or static plus simple cgis), have you considered
> using boa? [2] I use it for a large site that has a lot of static pages
> and it does great - it's a small, clean, minimal web server written in C.
>
> A final option is an accelerator cache [3]. Not sure if PG is using one
> yet, but it probably should be.
>
> [1] http://www.google.com/bot.html
>
> [2] http://www.boa.org/
>
> [3] http://www.squid-cache.org/Doc/FAQ/FAQ-20.html#what-is-httpd-accelerator
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)com
> PGP Key: 0x14964AC8 200408290732
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFBMcEGvJuQZxSWSsgRAhK9AKCLQ4CIW2JQQDg+BFI12DyhaFiFVgCg1DW5
> VkM2ayTI9OK6M1kIscAwgxs=
> =1uGd
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

pgsql-www by date

Next:From: Marc G. FournierDate: 2004-08-29 22:29:02
Subject: Re: Archives too slow
Previous:From: Hervé PiedvacheDate: 2004-08-29 18:59:39
Subject: [GENERAL] RSS Feeds are dead on Web site

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group