Re: [GENERAL] bytea Issue - Reg

2014-06-06 Thread Adrian Klaver
On 06/04/2014 10:49 PM, sramay wrote: Sir, The base table is having bytea and having records around 32 lakhs shows size of 300 mb. bytea field has attached documents size is not shown in the base table. The message on Tomcat is --begin text -- 4 Jun, 2014 3:29:07 PM org.apache.catalina.core.

Re: [GENERAL] bytea Issue - Reg

2014-06-06 Thread Alan Hodgson
On Wednesday, June 04, 2014 10:49:18 PM sramay wrote: > relation "public.file_attachments" does not exist .. is almost certainly not a size problem. What does your PostgreSQL log say? I suspect your app is connecting to the wrong database. -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] bytea Issue - Reg

2014-06-06 Thread sramay
Sir, The base table is having bytea and having records around 32 lakhs shows size of 300 mb. bytea field has attached documents size is not shown in the base table. The message on Tomcat is --begin text -- 4 Jun, 2014 3:29:07 PM org.apache.catalina.core.StandardWrapperValve invoke INFO: WARN [

Re: [GENERAL] bytea Issue - Reg

2014-06-04 Thread Adrian Klaver
On 06/03/2014 10:02 PM, sramay wrote: Sir, No it is reporting that base table is missing not the TOAST table. Is Streaming Replication can cause this issue?. What is the exact error message Tomcat is reporting? Data is not being aged which is much. As the records add during this period on

Re: [GENERAL] bytea Issue - Reg

2014-06-04 Thread sramay
Sir, No it is reporting that base table is missing not the TOAST table. Is Streaming Replication can cause this issue?. Data is not being aged which is much. As the records add during this period on the base table which is hardly 300 MB ( 3million records) . the db size 700 GB. Version I am

Re: [GENERAL] bytea Issue - Reg

2014-06-03 Thread Adrian Klaver
On 06/03/2014 01:25 AM, sramay wrote: Hi all, I am having a specifc issue of bytea. When we started storing more records in the database on bytea field on version 9.1.x the data has gone to pg_toast tables. The strange observation is now after a table size of 700 gb it now all of a sudden re

[GENERAL] bytea Issue - Reg

2014-06-03 Thread sramay
Hi all, I am having a specifc issue of bytea. When we started storing more records in the database on bytea field on version 9.1.x the data has gone to pg_toast tables. The strange observation is now after a table size of 700 gb it now all of a sudden reporting table not found on the tomcat lo