X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B6FCF3A4669 for ; Wed, 3 Nov 2004 20:54:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89168-07 for ; Wed, 3 Nov 2004 20:54:44 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 6A2783A4664 for ; Wed, 3 Nov 2004 20:54:43 +0000 (GMT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id C11D212A73D for ; Wed, 3 Nov 2004 16:54:41 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88420-09; Wed, 3 Nov 2004 20:54:40 +0000 (GMT) Received: from ganymede.hub.org (blk-222-46-91.eastlink.ca [24.222.46.91]) by hub.org (Postfix) with ESMTP id C629B12A73B; Wed, 3 Nov 2004 16:54:39 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id 6C1EF3DD9A; Wed, 3 Nov 2004 16:54:41 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 5F1FD3DD99; Wed, 3 Nov 2004 16:54:41 -0400 (AST) Date: Wed, 3 Nov 2004 16:54:41 -0400 (AST) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: "Joshua D. Drake" Cc: pgsql-www@postgresql.org Subject: Re: projects.postgresql.org In-Reply-To: <41894169.6080000@commandprompt.com> Message-ID: <20041103165358.J82047@ganymede.hub.org> References: <418939D7.1060803@commandprompt.com> <20041103161356.S82047@ganymede.hub.org> <41894169.6080000@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/56 X-Sequence-Number: 5787 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