[ADMIN] regression database

Hello,   I inherited a production Postgres database server which has a "Regression" database. The problem is that the size of the objects with in the Regression database are increasing so much that the database has grown into several GB.  (Ex: pg_attribute and its index have grown into 2GB each and

Re: [ADMIN] regression database

    So am not sure why this thing is growing progressively. Any feedback/ help is greatly appreciated.   thanks, Kris Pal.Tom Lane <[EMAIL PROTECTED]> wrote: kris pal <[EMAIL PROTECTED]>writes:> I am not sure what the implications of completely deleting the> 'Regressi

Re: [ADMIN] regression database

ute etc are still so huge and I have no idea why. This table is not the one we created in the schema.   thanks, Kris Pal. kris pal <[EMAIL PROTECTED]> wrote: Hi tom,   It is actually named 'regression'. I spoke with the person who build the server but apparently he is not well wors

Re: [ADMIN] vacuum pg_attribute causes high load

can find some reading material abt FSM settings and default values?   thanks, Kris Pal.   Tom Lane <[EMAIL PROTECTED]> wrote: kris pal <[EMAIL PROTECTED]>writes:> Actually I just noticed something. Previously for some reason, I> thought the data directory corresponded to 'regr

Re: [ADMIN] vacuum pg_attribute causes high load

  >>> 1) Can you tell me if there is any other work around to vacuum the>> pg_attribute system table ? Like doing it in parts so that it won't> >cause a high load. Chris Browne <[EMAIL PROTECTED]> wrote:>No, you need to let the vacuum finish. >If you stop it early, it'll jus

Re: [ADMIN] vacuum pg_attribute causes high load

om step 1) into bmgs created in  step 3)     Do you think there will be issues with this approach? The system catalog will be built from scratch, and there won't be any data loss right. That way I can reclaim the space and then run Vacuum more often.   thanks, Kris Pal.   Christopher Brown

Re: [ADMIN] vacuum pg_attribute causes high load

on database(bgms) and imported it into a test database (test). It went through fine with in few minutes. So I guess the ordering of the objects is fine.  My only concern is abt the system catalog. Do we need anything else from the original database "bgms"  other than the Dump file to recre

Re: [ADMIN] repeat Q: pg_attribute - Index

;t want to drop and reimport the whole database everytime.   thanks, Kris Pal. kris pal <[EMAIL PROTECTED]> wrote: I am running 7.4.1 on Linux 2.4.21-15.ELsmp kernel.   thanks, Kris Pal. Tom Lane <[EMAIL PROTECTED]> wrote: kris pal <[EMAIL PROTECTED]>writes:> 1) E