Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 36D5A9FBC97 for ; Tue, 23 Oct 2007 17:43:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21991-09 for ; Tue, 23 Oct 2007 17:43:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 1CD139FB545 for ; Tue, 23 Oct 2007 17:43:17 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so198000ugf for ; Tue, 23 Oct 2007 13:43:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=KvQu0aB43ZeOFFWV3bApA5346tIwom/vo+7KNnfFIdU=; b=lsEIGq+jEYqTKJfF/c1ph5Dza4/aYnKf0sAK5YzUJqwOLTdJKN6G9G4AJSivt1FFmnl8Cd9Jle+6JFQ7j2F51XztfhE/kDh9g1OOt1iNnxml7M2fEhzf+jvsWNvA76du3PGMr8VQmziMp1xBBDo+PS2687PC3nOOaa4/1hhrvGw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NXA3lkguiyAKWXEZoVcvFGFCllGlVA13SreUB76gZ8b/AVhRkiJO/VH2B34ScW+tEp35OrZqOBYqkRv8Dvi9bS+ojWNvXR2RI7X+6OkghhTGi7tvZM6GHX1AOLMIkMF2oPr5dORifggyKv7pfjgWgh7Jka+YLn0NuhoPdcdyOVc= Received: by 10.67.116.4 with SMTP id t4mr1239653ugm.1193172193794; Tue, 23 Oct 2007 13:43:13 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Tue, 23 Oct 2007 13:43:13 -0700 (PDT) Message-ID: Date: Tue, 23 Oct 2007 15:43:13 -0500 From: "Scott Marlowe" To: "Martin Strejc" Subject: Re: pg_toast Cc: pgsql-admin@postgresql.org In-Reply-To: <471E002F.4030004@super-web.cz> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <471E002F.4030004@super-web.cz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/226 X-Sequence-Number: 27140 On 10/23/07, Martin Strejc wrote: > 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. This is all a little vague. What were the sequence of events, and what were the actual error messages you got? What do you mean by froze? how long was it not returning, and what did you do to unfreeze it, if anything? what are your postgresql.conf settings, specifically the ones you've changed. What does the output of vacuum verbose on this database say? Specifically the last 5 or 10 lines. The more info you can give us about your problem, the better we can help. > Is it possible to delete any of pg_toast or pg_temp tables? How to > do that if possible? Not a good idea. pg_temp tables will usually not be an issue, unless you're running out of free disk space. pg_toast is where your overlarge text fields go.