X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C62BB52A0F for ; Thu, 30 Jun 2005 13:23:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31468-05 for ; Thu, 30 Jun 2005 16:23:23 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.200]) by svr1.postgresql.org (Postfix) with ESMTP id 67EA9529E7 for ; Thu, 30 Jun 2005 13:23:22 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id x37so37189nfc for ; Thu, 30 Jun 2005 09:23:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=iYdV3x9Ixh059xKPVP+uxhp1OxuBNusmQkMuPjkwqBG6Ch59rgYR9oLcKL7905N9nsIIVqqQD4TUl3l5JJvDN30hnIInBj+Gb+ESaPcWmn/+/shEzbcaWeMVrKPNxC1/XZyE7kcnEqqxQ7rLrnAQ/9jGka2e0R8DAor0g/5Q1Yk= Received: by 10.48.239.10 with SMTP id m10mr26028nfh; Thu, 30 Jun 2005 09:23:22 -0700 (PDT) Received: by 10.48.49.14 with HTTP; Thu, 30 Jun 2005 09:23:22 -0700 (PDT) Message-ID: <4b09a0c0506300923622887d@mail.gmail.com> Date: Thu, 30 Jun 2005 18:23:22 +0200 From: Jean-Max Reymond Reply-To: Jean-Max Reymond To: pgsql-performance@postgresql.org Subject: Re: start time very high In-Reply-To: <4b09a0c050630084260f12728@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <4b09a0c050630084260f12728@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/598 X-Sequence-Number: 13235 2005/6/30, Jean-Max Reymond : > so the request run in 26.646 ms on the Sun and 0.469ms on my laptop :-( > the database are the same, vacuumed and I think the Postgres (8.0.3) > are well configured. > The Sun has two disks and use the TABLESPACE to have index on one disk > and data's on the other disk. > It seems that the cost of the first sort is very high on the Sun. > How is it possible ? may be data's not loaded in memory but on disk ? --=20 Jean-Max Reymond CKR Solutions Open Source Nice France http://www.ckr-solutions.com