Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 583551337B97 for ; Fri, 6 May 2011 04:55:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16061-04 for ; Fri, 6 May 2011 07:55:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.smtpout.orange.fr (smtp06.smtpout.orange.fr [80.12.242.128]) by mail.postgresql.org (Postfix) with ESMTP id C82D11337A67 for ; Fri, 6 May 2011 04:55:37 -0300 (ADT) Received: from [10.100.1.32] ([80.13.5.220]) by mwinf5d11 with ME id g7va1g00D4kpSGo037val3; Fri, 06 May 2011 09:55:36 +0200 Message-ID: <4DC3A976.7050707@hbs-research.com> Date: Fri, 06 May 2011 09:55:34 +0200 From: adrien ducos User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Kevin Grittner CC: "pgsql-admin@postgresql.org" Subject: Re: My server is oddly very slow References: <4DC17AAB.1080206@hbs-research.com> <4DC14AA6020000250003D28B@gw.wicourts.gov> <4DC275A8.8000400@hbs-research.com> <4DC29710020000250003D300@gw.wicourts.gov> In-Reply-To: <4DC29710020000250003D300@gw.wicourts.gov> Content-Type: text/plain; charset=iso-8859-15; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201105/62 X-Sequence-Number: 37499 Kevin Grittner a écrit : > adrien ducos wrote: > >> Kevin Grittner a écrit : >> > > >>> What does this show?: >>> >>> free -m >>> > > >> total used free shared buffers cached >> Mem: 3042 3000 41 0 4 2896 >> -/+ buffers/cache: 99 2942 >> Swap: 1983 1 1982 >> > > This was while the PostgreSQL server was running and showing > shared_buffers = 512MB? If so, there's something seriously wrong > with your OS. > > >>> The first line in vmstat (which is all you get if you run it >>> without a number) is averages since the OS was booted. That's >>> not usually very helpful. What does this show?: >>> >>> vmstat 1 >>> > > >> same for vmstat 1 while runing the query >> >> vmstat 1 >> procs -----------memory---------- ---swap-- -----io---- -system-- >> r b swpd free buff cache si so bi bo in cs >> 0 0 1280 45752 4496 2963460 0 0 29 45 0 1 >> > > Those look like the sort of useless numbers you get on the *first* > line of vmstat, even with a number. What did a few of the *other* > lines look like while the query was running? > > -Kevin > . > > They Look exactly the same as the first one, with cache changing form 2963460 to 2961000 so not much difference at all... So what you say is what I thought, there is something wrong with the OS... we will try to put centos (the same OS as in development) instead of redhat the OS installed by the internet provider and see how it goes. Thanks for your feedback. Adrien -- Logo_HBS_mail.jpg Adrien DUCOS Analyste développeur aducos@hbs-research.com www.hbs-research.com +33 (0)9 70 44 64 10 24 rue de l'Est 75020 Paris