X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 08F52D1BA3E for ; Fri, 22 Aug 2003 21:04:42 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 06074-03 for ; Fri, 22 Aug 2003 21:04:40 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 03B04D1BA29 for ; Fri, 22 Aug 2003 21:04:31 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3540518; Fri, 22 Aug 2003 17:02:05 -0700 Content-Type: text/plain; charset="iso-8859-2" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Tomka Gergely , Robert Treat Subject: Re: Tests Date: Fri, 22 Aug 2003 17:00:17 -0700 User-Agent: KMail/1.4.3 Cc: Bill Moran , References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200308221700.17201.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/319 X-Sequence-Number: 3135 Tomka, Since this didn't post last time: Another good test to do would be one that measures simultaenous steaming=20 read-write. For example: create table_a, with at least 10,000 records, where field1 is the PK and=20 field2 is a text field.=20=20=20 create table_b, with 500,000 or more records, where field2 is an FK to=20 table_a, and field_3 is a text field. do the following: UPDATE table_b SET field3 =3D field3 || 'something' WHERE EXISTS (select field1 FROM table_a where table_a.field1 =3D table_b.field2 AND table_a.field_2 =3D 'x') For the test to be most effective, the condition above should affect about= =20 100,000 records of table_a, and the records should not be contiguos on disk= .=20=20 Further, tablea.field2 should not be indexed in order to force a disk scan. Also another test I'd really like to see is hardware raid (Adaptec, LSI)=20 against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. --=20 -Josh Berkus Aglio Database Solutions San Francisco