From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
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 03:02:49 |
Message-ID: | 20040828235957.R34829@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
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 ...
Will work on this this weekend
On Sat, 28 Aug 2004, Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> I am not happy with how slow the archives site is. It reflects
> bad on PostgreSQL and supports the stereotype of PG being "slow".
> For example, this page:
>
> http://archives.postgresql.org/pgsql-hackers-win32/2004-07/msg00003.php
>
> took 27 seconds to load completely. Some days, the times are better, but
> it always takes a notieeable delay for the page to load. It also seems
> to load in three sections: the top banner ad / search box, the title
> and header section, and then the rest of the page. The first two load
> today in about 10 seconds, the third about 16 seconds after that.
> Subsequent hits tend to be much faster (disk caching one presumes), so
> if you test, change the above URL to a random month, day, and message.
> I don;t think it is on my end: I'm on a very fast connection, and (for
> comparison) pgsql.ru loads very, very fast, and runs it searches of
> the entire archives faster than arhives.postgresql.org can display
> a single message.
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)com
> PGP Key: 0x14964AC8 200408281951
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFBMRs3vJuQZxSWSsgRAgTqAJ4rjb9HpR+glJS4y4fGYrTLnahIxwCgjrUv
> WteQbp0fd3QaZPbVb5wZM+4=
> =puf4
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2004-08-29 04:43:53 | Techdocs site down (db error) |
Previous Message | Bruce Momjian | 2004-08-29 00:24:06 | Re: Archives too slow |