Re: tables filled to 1 Gig each - Mailing list pgsql-general

From Scott Marlowe
Subject Re: tables filled to 1 Gig each
Date
Msg-id dcc563d10904071345j463047cfu637ba94272ebfd14@mail.gmail.com
Whole thread Raw
In response to tables filled to 1 Gig each  (Cha Yang <chay@stopware.com>)
List pgsql-general
On Tue, Apr 7, 2009 at 1:36 PM, Cha Yang <chay@stopware.com> wrote:
> Postgresql 8.2
> backend to a Java application with JDBC
>
>
> For whatever reason all of postgresql tables all filled up to 1 gig each
> Accessing Postgresql through either the application or PGadmin fails

When they get to 1gig they start a new segment, so they look like:

12345.1
12345.2
12345.3

No problem

> any ideas of how to get into Postgresql or a way to clean up these tables?

You don't need to clean it up.  What are the actual symptoms of a
failure, if any, you are having?

pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: INSERT or UPDATE TRIGGER
Next
From: Bruce Momjian
Date:
Subject: Re: Anyone testing changes to libpq/bcc32.mak?