Re: [GENERAL] vacuum vs pg_repack vs pg_reorg

Hi Mr Kevin, Thanks for the suggestion, VACUUM analyze is a much simpler solution compared to rest. Thanks once more. Regards Ramachandran S -- View this message in context: http://postgresql.nabble.com/vacuum-vs-pg-repack-vs-pg-reorg-tp5832261p5832499.html Sent from the PostgreSQL - genera

[GENERAL] vacuum vs pg_repack vs pg_reorg

Hi, I have a database of size 1.5 TB. The attachments are stored in bytea. The attachment table is consuming maximum space. The database version is 9.1.x and Streaming Replication is set. Now, I have to removed old records to make way for new records without increasing SAN Space. Which will

Re: [GENERAL] bytea Issue - Reg

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

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

[GENERAL] bytea Issue - Reg

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

Re: [GENERAL] pg_largeobject related issue with 9.2

Hi Kevin, >From Mr Momijan's suggestion by running the following query, I was in a position to create the pg_largeobject_metadata table instead of copying, I assumed that postgres is the user at source and hence it should work for destination also. But by running the following command select

Re: [GENERAL] pg_largeobject related issue with 9.2

Hi Kevin, Thanks for the prompt answer. The Page 0 of the record is very much existing. But still If take a dump of pg_largeobject_metadata from source database still the same message. The database runs under the 'postgres' superuser only. Can I recreate the pg_largeobject_metadata by which co

Re: [GENERAL] pg_largeobject related issue with 9.2

Hi Kevin, I will use whatever techniques you have mentioned. The situation is unique there was no backup for 300+ GB Database. If I give the command select * from pg_largeobject where loid=141066; it is showing 3 rows But whenever I want to export to lo_export it says loid missing it says

[GENERAL] pg_largeobject related issue with 9.2

Hi, I am having a application which was running on Jboss 5 with Hibernate and PostgreSQL 9.2. Due to media corruption. Data without largeobject was restored and largeobject I restored from some other source. Now the application is giving error eventhough largeobject is present it is giving e

[GENERAL] General Query on Roles - Reg

Hi, I always use a community source, compile and use for all those projects. I have doubt Assume I am creating a user say 'test' with nosuperuser privilege with just login and associate this user with any database using authorization. But I am able to create a table for the test user in 'postgre