Message-ID: <41894169.6080000@commandprompt.com>
Date: Wed, 03 Nov 2004 12:36:57 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla Thunderbird 0.8 (X11/20040913)
MIME-Version: 1.0
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: pgsql-www@postgresql.org
Subject: Re: projects.postgresql.org
References: <418939D7.1060803@commandprompt.com>
	<20041103161356.S82047@ganymede.hub.org>
In-Reply-To: <20041103161356.S82047@ganymede.hub.org>
Content-Type: multipart/mixed; boundary="------------040505050102030004020205"

This is a multi-part message in MIME format.
--------------040505050102030004020205
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> 
> 
> 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@hub.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@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

--------------040505050102030004020205
Content-Type: text/x-vcard; charset=utf-8;
 name="jd.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="jd.vcf"

begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We  provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored  the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard


--------------040505050102030004020205--