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@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
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
