X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2785647629F for ; Tue, 4 Mar 2003 12:30:32 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 44002-07 for ; Tue, 4 Mar 2003 12:30:27 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 32B5A476291 for ; Tue, 4 Mar 2003 12:30:09 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2879453; Tue, 04 Mar 2003 09:29:58 -0800 Content-Type: text/plain; charset="us-ascii" From: Josh Berkus Organization: Aglio Database Solutions To: michael@linuxmagic.com Subject: PostgreSQL Performance Issue on Mail Server Date: Tue, 4 Mar 2003 09:29:28 -0800 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Message-Id: <200303040929.28743.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/17 X-Sequence-Number: 1315 Mr. Peddermors, "We have a postgres backend to our Mail Server product, and encountering=20 performance issues. Simple selects are taking 7-10 seconds..=20 We have of course applied all the suggested performance settings for Postgr= es,=20 (We are running on Debian Stable/Linux BTW) We moved the database to a standalone server, but still having the problems. With app 100,000 users authenticating pop mail, plus all of the smtp=20 verfications, the server is expected to perform snappy queries, else mail= =20 delivery/pickup is inordintaely long, or can't occur, and loads snowball.." I've cc'd your question to PGSQL-Performance list. Can you give us a f= ew=20 examples of EXPLAIN ANALYZE output for the queries which are running slow?= =20 (as well as the queries themeselves)? It's possible that you have a=20 platform issue on Debian, but far more likely that this is a garden-variety= =20 performance tuning issue. If this is a business-critical issue, I suggest that you retain a PostgreSQ= L=20 consultant, such as PostgreSQL Inc., myself, or Justin Clift. --=20 Josh Berkus Aglio Database Solutions San Francisco