X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E220752838 for ; Thu, 9 Jun 2005 08:14:16 -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 34198-10 for ; Thu, 9 Jun 2005 11:14:07 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by svr1.postgresql.org (Postfix) with ESMTP id EE00C52896 for ; Thu, 9 Jun 2005 08:14:06 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 12so85479nzp for ; Thu, 09 Jun 2005 04:14:09 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=T+UrhDwzQzhn5lJ4JAT6LrgMA0f1ql7SgFOSBjrLw109J44rzz5owuD/r59oZc6na8hPXoe46sTwr4KUP56sqZPN6/RNqtj3456Xm63xgilzpa4s5sFswoIz/5QoC6ZdnO4FX0UNwV+kbs+ADgoMyI3hNgWSUh4XmXyk5SHcF3I= Received: by 10.36.222.44 with SMTP id u44mr344955nzg; Thu, 09 Jun 2005 04:14:09 -0700 (PDT) Received: by 10.36.22.20 with HTTP; Thu, 9 Jun 2005 04:14:09 -0700 (PDT) Message-ID: <758d5e7f050609041433c86c69@mail.gmail.com> Date: Thu, 9 Jun 2005 13:14:09 +0200 From: Dawid Kuroczko Reply-To: Dawid Kuroczko To: =?ISO-8859-1?Q?K=D6PFERL_Robert?= Subject: Re: Stripping raid vs. table spaces Cc: pgsql-admin@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.633 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/56 X-Sequence-Number: 17811 On 6/9/05, K=D6PFERL Robert wrote: > Short question: >=20 > Is it enugh to have stripping on a disk array? > Are table spaces then of less use than the actual stripping? So will just > stripping give me more O/I-performance? Short answer: if you make one striping partition -- you have better overall performance. if you distribute tables using tablespaces -- you make tables performance more independant from other tables. I.e. large load on one table has less impact on the load on the other table. Personally I would keep indexes on one set of drives and data on other. All depends on your setup.