Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6028476819 for ; Thu, 16 Jan 2003 08:54:37 -0500 (EST) Received: from web21106.mail.yahoo.com (web21106.mail.yahoo.com [216.136.227.108]) by postgresql.org (Postfix) with SMTP id 4E0A7476B85 for ; Thu, 16 Jan 2003 08:51:37 -0500 (EST) Message-ID: <20030116135140.32097.qmail@web21106.mail.yahoo.com> Received: from [140.247.91.110] by web21106.mail.yahoo.com via HTTP; Thu, 16 Jan 2003 05:51:40 PST Date: Thu, 16 Jan 2003 05:51:40 -0800 (PST) From: CaptainX0r Reply-To: captainx0r@yahoo.com Subject: schema/db design wrt performance To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/142 X-Sequence-Number: 789 All, I just noted in another thread that use of foreign keys in postgres significantly hinders performance. I'm wondering what other aspects we should take into consideration in the design of our database. We're coming from Sybase and trying to design a more encompassing, modular, generic database that won't take a serious performance hit under postgres. Thanks, -X __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com