From: Duan Ligong <l-duan@zd.cnes.jp.nec.com>
To: pgsql-admin@postgresql.org
Subject: Re: store different tables in different locations
Date: Mon, 7 Apr 2008 10:38:15 +0900
Message-ID: <008801c89850$0cb6a080$f623480a@nsl.ad.nec.co.jp> (raw)
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>
<47F662B4.7080903@Sheeky.Biz>
Shane Ambler wrote:
> 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?
Well, In order to keep my system running 7x24, I make a cluster for it
with the third-party cluster software and the size of mirror disk where the
data is rcped to the backup server in time automatically is 1GB.
> 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
There are several tables where the rows are frequently updated and inserted
and deleted.
>
> What is the exact message you get in regards to this limit?
> And where does this appear to come from?
The size of mirror disk is 1GB, on which I cannot decided.
> --
>
> Shane Ambler
> pgSQL (at) Sheeky (dot) Biz
>
> Get Sheeky @ http://Sheeky.Biz
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: l-duan@zd.cnes.jp.nec.com
Subject: Re: store different tables in different locations
In-Reply-To: <008801c89850$0cb6a080$f623480a@nsl.ad.nec.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox