Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA23805 for postgres-dist; Sun, 20 Mar 1994 20:59:45 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403210459.UAA23805@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from kaukau.comp.vuw.ac.nz (kaukau.comp.vuw.ac.nz [130.195.5.20]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id UAA23796 for ; Sun, 20 Mar 1994 20:59:43 -0800 Received: from downstage.comp.vuw.ac.nz (downstage.comp.vuw.ac.nz [130.195.6.10]) by kaukau.comp.vuw.ac.nz (8.6.7/8.6.6) with ESMTP id QAA29974 for ; Mon, 21 Mar 1994 16:59:12 +1200 From: Aaron Roydhouse Received: from downstage.comp.vuw.ac.nz (aaron@localhost) by downstage.comp.vuw.ac.nz (8.6.8/8.6.6) with ESMTP id QAA26768 for ; Mon, 21 Mar 1994 16:59:28 +1200 Message-Id: <199403210459.QAA26768@downstage.comp.vuw.ac.nz> To: postgres@postgres.Berkeley.EDU Subject: Scaling Postgres to larger databases Date: Mon, 21 Mar 1994 16:59:28 +1200 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Sun, 20 Mar 94 20:59:45 -0800 Resent-XMts: smtp In my current application my largest relation contains about 5,500 records, and the relations and associated indices occupy about 20Mb. In the next few months I want to evaluate my system on a reasonably sized database. I expect the largest relations to contain about 150,000 records plus indices. Overall I'd estimate it will require about 600Mb plus working space for queries. I'd like to hear from anyone using Postgres with databases over 5,000 records or 20Mb, and especially people with over 50,000 records or 100Mb. Also, if the development team have any comments about the feasibility of my intentions, I'd really appreciate any advice. I'll summarise and mail to the list. Thanks, Aaron.