Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id DC36A2E00DF for ; Fri, 4 Apr 2008 15:31:38 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 27904-02-4 for ; Fri, 4 Apr 2008 15:31:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ipmail01.adl6.internode.on.net (ipmail01.adl6.internode.on.net [203.16.214.146]) by developer.postgresql.org (Postfix) with ESMTP id 185112E00F2 for ; Fri, 4 Apr 2008 15:24:24 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApsEAJv89UfLevdH/2dsb2JhbACBWqol X-IronPort-AV: E=Sophos;i="4.25,605,1199626200"; d="scan'208";a="75909038" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail01.adl6.internode.on.net with ESMTP; 05 Apr 2008 03:47:41 +1030 Message-ID: <47F662B4.7080903@Sheeky.Biz> Date: Sat, 05 Apr 2008 03:47:40 +1030 From: Shane Ambler User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213) MIME-Version: 1.0 To: Julius Tuskenis CC: pgsql-admin@postgresql.org Subject: Re: store different tables in different locations References: <011101c89609$eaa96060$131c480a@nsl.ad.nec.co.jp> <47F5C8D7.9070904@nsoft.lt> <014601c89626$065d4a80$131c480a@nsl.ad.nec.co.jp> <47F5E12B.70701@nsoft.lt> In-Reply-To: <47F5E12B.70701@nsoft.lt> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/43 X-Sequence-Number: 28807 Julius Tuskenis wrote: >> For some reason the size of database is asked to restrict to 900MB. >> So I have to make efforts to make sure that its size is less than 900MB. Two things I can think of that may get you a message like this. 1. Available disk space (or quotas for the postgres user) - which partition is the db on and how much free space does it have? 2. You are storing all data in the same row and column (as in adding to data there not inserting data into a new row) which is restricted to 1GB What is the exact message you get in regards to this limit? And where does this appear to come from? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz