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 09DBDD1C941 for ; Wed, 23 Jul 2003 02:10:17 +0000 (GMT) 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 12067-03 for ; Tue, 22 Jul 2003 23:09:34 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 28552D1C4BF for ; Tue, 22 Jul 2003 23:10:15 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 6952B10258; Tue, 22 Jul 2003 22:03:17 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-81.tor.dsl.tht.net [134.22.133.81]) by mailav.tor1.inquent.com (Postfix) with ESMTP id E83BD1024D; Tue, 22 Jul 2003 22:03:14 -0400 (EDT) Subject: Re: One table or many tables for data set From: Rod Taylor To: "Castle, Lindsay" Cc: Postgresql Performance In-Reply-To: <1058925003.47745.15.camel@jester> References: <1058925003.47745.15.camel@jester> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-zT3BZMtxJMXfN9v6wb7l" Message-Id: <1058926258.47745.20.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 22 Jul 2003 22:10:59 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/386 X-Sequence-Number: 2679 --=-zT3BZMtxJMXfN9v6wb7l Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2003-07-22 at 21:50, Rod Taylor wrote: > Ok.. Unless I'm missing something, the data will be static (or near > static). It also sounds as if the structure is common for elements, so > you probably only want 2 tables. I misunderstood. Do what Joe suggested. --=-zT3BZMtxJMXfN9v6wb7l Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/He6y6DETLow6vwwRAhXSAJoDl/cUd3vyGXxB0BrogLYnZYRXHgCfXi8P Jp6rOaeuIs8o/yAOucPOAgw= =G24L -----END PGP SIGNATURE----- --=-zT3BZMtxJMXfN9v6wb7l--