Re: projects.postgresql.org

Hello,

The projects site seems awful slow today... No bandwidth issues that I
can see. Any ideas?

Sincerely,

Joshua D. Drake

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Joshua D. Drake wrote:
> Hello,
>
> The projects site seems awful slow today... No bandwidth issues that I
> can see. Any ideas?

Yes, I saw this yesterday and I think Marc is looking into it.

--
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

On Wed, 3 Nov 2004, Joshua D. Drake wrote:

> Hello,
>
> The projects site seems awful slow today... No bandwidth issues that I
> can see. Any ideas?

Try it now ... seems okay to me, but I just ran a vacuum full on her
database too ... teach me to rely on pg_autovacuum for it all :(

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

>
>
> Try it now ... seems okay to me, but I just ran a vacuum full on her
> database too ... teach me to rely on pg_autovacuum for it all :(

Nope still seems slow. In fact it is timing out sometimes... Here is a ab:

Server Software: Apache/1.3.31
Server Hostname: projects.postgresql.org
Server Port: 80

Document Path: /
Document Length: 0 bytes

Concurrency Level: 10
Time taken for tests: 65.803268 seconds
Complete requests: 100
Failed requests: 0
Write errors: 0
Non-2xx responses: 100
Total transferred: 23800 bytes
HTML transferred: 0 bytes
Requests per second: 1.52 [#/sec] (mean)
Time per request: 6580.327 [ms] (mean)
Time per request: 658.033 [ms] (mean, across all concurrent requests)
Transfer rate: 0.35 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 157 184 20.5 182 239
Processing: 635 6107 3198.7 6117 15164
Waiting: 635 6088 3190.6 6072 15164
Total: 830 6292 3199.9 6329 15326

Percentage of the requests served within a certain time (ms)
50% 6329
66% 7772
75% 8637
80% 9128
90% 10491
95% 11948
98% 13061
99% 15326
100% 15326 (longest request)

Sincerely,

Joshua D. Drake

>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

am working on it ...

On Wed, 3 Nov 2004, Joshua D. Drake wrote:

>>
>>
>> Try it now ... seems okay to me, but I just ran a vacuum full on her
>> database too ... teach me to rely on pg_autovacuum for it all :(
>
> Nope still seems slow. In fact it is timing out sometimes... Here is a ab:
>
> Server Software: Apache/1.3.31
> Server Hostname: projects.postgresql.org
> Server Port: 80
>
> Document Path: /
> Document Length: 0 bytes
>
> Concurrency Level: 10
> Time taken for tests: 65.803268 seconds
> Complete requests: 100
> Failed requests: 0
> Write errors: 0
> Non-2xx responses: 100
> Total transferred: 23800 bytes
> HTML transferred: 0 bytes
> Requests per second: 1.52 [#/sec] (mean)
> Time per request: 6580.327 [ms] (mean)
> Time per request: 658.033 [ms] (mean, across all concurrent requests)
> Transfer rate: 0.35 [Kbytes/sec] received
>
> Connection Times (ms)
> min mean[+/-sd] median max
> Connect: 157 184 20.5 182 239
> Processing: 635 6107 3198.7 6117 15164
> Waiting: 635 6088 3190.6 6072 15164
> Total: 830 6292 3199.9 6329 15326
>
> Percentage of the requests served within a certain time (ms)
> 50% 6329
> 66% 7772
> 75% 8637
> 80% 9128
> 90% 10491
> 95% 11948
> 98% 13061
> 99% 15326
> 100% 15326 (longest request)
>
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>>
>> ----
>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
> --
> Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664