Re: [GENERAL] Large database - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [GENERAL] Large database
Date
Msg-id 199908171838.OAA01135@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] Re: [GENERAL] Large database
List pgsql-hackers
> > > i filed a bug report at one time noting that:
> > > "ALTER TABLE tbname RENAME TO tbname_new;"
> > > was not renaming all of the extents.
> > > 
> > > do you know if this has been fixed?
> > 
> > Yes, in 6.5.*.
> 
> cool.
> 
> if i'm annoying you, tell me to go away.
> 
> do you know why vacuum can consume an enormous amount of core when cleaning
> a large table?
> 
> i've actually had to add a gig of swap to our server so that vacuum can
> actually finish on some of our tables.
> 
> sometimes the vacuum won't even do that, and i need to:
> 
> pg_dump -t tb -s db > tb.dmp
> psql -c "copy tb to stdout using delimiters ':';" db | gzip > tb.dat.gz
> psql -c "drop table tb;" db
> psql -e db < tb.dmp
> zcat tb.dat.gz | psql -c "copy tb from stdin using delimiters ':';" db
> 
> very painful (taking several hours).

Can someone comment on the high memory usage of vacuum?


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Ricardo Coelho"
Date:
Subject: Drop group problem and DENY command
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [CORE] Re: tomorrow