Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E0E2E2E106F for ; Tue, 15 Jan 2008 08:26:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 62041-08 for ; Tue, 15 Jan 2008 08:26:14 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id BF5482E0268 for ; Tue, 15 Jan 2008 08:26:12 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 82594B7A4A for ; Tue, 15 Jan 2008 14:26:13 +0200 (SAST) Message-ID: <478CA662.4060505@careerjunction.co.za> Date: Tue, 15 Jan 2008 14:26:10 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores References: <7083.1199379570@sss.pgh.pa.us> <477D1D59.7050002@comgate.cz> <4782063C.7070105@comgate.cz> <26502.1199745090@sss.pgh.pa.us> <4782AB4D.8010009@comgate.cz> <27655.1199750492@sss.pgh.pa.us> <47836A4C.5080707@comgate.cz> <10713.1199813111@sss.pgh.pa.us> <47874EE8.2050406@comgate.cz> <12997.1200063940@sss.pgh.pa.us> <478B4BB9.4030208@comgate.cz> <13894.1200324134@sss.pgh.pa.us> <478CA26E.9040105@comgate.cz> In-Reply-To: <478CA26E.9040105@comgate.cz> Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/124 X-Sequence-Number: 28363 Hi > > I can think of three things that might be producing this: > > we've found it: TRUNCATE I haven't been following this thread. Can someone please explain to me why TRUNCATE causes these spikes? -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842