Thread: tables filled to 1 Gig each

tables filled to 1 Gig each

From
Cha Yang
Date:
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

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


thanks





Re: tables filled to 1 Gig each

From
Scott Marlowe
Date:
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?