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