Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C8C4E9FC646 for ; Tue, 23 Oct 2007 11:33:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 05380-06-4 for ; Tue, 23 Oct 2007 11:33:31 -0300 (ADT) X-Greylist: delayed 00:24:39.458362 by SQLgrey-1.7.5 Received: from srv01.super-web.cz (super-web.cust.ignum.cz [217.31.58.160]) by postgresql.org (Postfix) with ESMTP id E90D79FC619 for ; Tue, 23 Oct 2007 11:33:11 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by srv01.super-web.cz (Postfix) with ESMTP id 85A05328138 for ; Tue, 23 Oct 2007 14:08:29 +0000 (UTC) X-Virus-Scanned: amavisd-new at localhost Received: from srv01.super-web.cz ([127.0.0.1]) by localhost (srv01.super-web.cz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fLydAAxR+iSU for ; Tue, 23 Oct 2007 16:08:23 +0200 (CEST) Received: from [192.168.1.84] (klient92-38.sxg.cz [62.77.92.38]) by srv01.super-web.cz (Postfix) with ESMTP id 57531328130 for ; Tue, 23 Oct 2007 16:08:23 +0200 (CEST) Message-ID: <471E002F.4030004@super-web.cz> Date: Tue, 23 Oct 2007 16:07:43 +0200 From: Martin Strejc User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_toast Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/223 X-Sequence-Number: 27137 Hi! I've a special kind of problem with PostgreSQL 8.2.5 and I haven't found anything about that on your web or searchig by Google. The database slows down when more over many (cca 100 connections) are incoming. The problem begun the same time as the VACUUM foroze on pg_toast.pg_toast without any reason or message in log. Actually it got after that troubles with reindex and VACUUM ANALYZE. Of course the shmmax, shared mem, max connections and some other parameter in postgresql.conf are set to get the best preformance of the server. Should you give me an advice what to do and how to help the database engine to work correctly? Is it possible to delete any of pg_toast or pg_temp tables? How to do that if possible? Thank you for your help. Martin Strejc server admin