X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 823F93A5F13 for ; Tue, 7 Dec 2004 07:58:21 +0000 (GMT) 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 71831-08 for ; Tue, 7 Dec 2004 07:58:11 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id E016A3A5645 for ; Tue, 7 Dec 2004 07:58:09 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id F006331941; Tue, 7 Dec 2004 08:58:06 +0100 (MET) From: "Rosny" X-Newsgroups: pgsql.performance Subject: Re: TableSpace Design issues on Postgres 8.0 beta 5 Date: Mon, 6 Dec 2004 23:58:06 -0800 Organization: Hub.Org Networking Services Lines: 38 Message-ID: References: <10164.1102394676@sss.pgh.pa.us> Reply-To: "Rosny" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.181 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.264 tagged_above=0 required=5 tests=AWL, FORGED_HOTMAIL_RCVD2, PRIORITY_NO_NAME X-Spam-Level: ** X-Archive-Number: 200412/151 X-Sequence-Number: 9526 Thanks for the response. I just start to get a feel of where TableSpace will be used. You are right I do not have 7000 logical filesystems. I am assuming using TableSpace as organization of files in folders in Windows 2003 Environment. So, each TableSpace will represent one folder(directory) in a drive. But this doesnot work to well for my design. Since pgAdmin III GUI take 2 hours just to load approximately 14000 tables. I am not using TableSpace approach anymore. I am using multiple database approach. Anyway, thanks for the response. Today testing by taking several option to the limit. I kind of having some ideas for future scability. Rosny "Tom Lane" wrote in message news:10164.1102394676@sss.pgh.pa.us... > "Rosny" writes: > > B. For each department create tablespace. (Which means, if there > > are 7000 departments, there will be 7000 tablespace each contains > > 20 tables). > > If your system has seven thousand separate logical filesystems attached > to it, there might be some value in having seven thousand tablespaces. > But I will bet a great deal that it does not and there isn't. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >