o you.
>
> On Mon, 2002-12-30 at 13:12, HT Levine wrote:
> > "Tom Lane" <[EMAIL PROTECTED]> wrote in message
> > >
> > > 1. You don't need to take down the DB to do vacuuming.
> >
> >
> > when I tried the vacuum with the site sti
CTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "HT" <[EMAIL PROTECTED]> writes:
> > We have quite large production Postgres 7.2 DB which is out of control
in
> > terms of disk consumption. We made it thru the holiday shopping
season,
Background:
We have quite large production Postgres 7.2 DB which is out of control in
terms of disk consumption. We made it thru the holiday shopping season,
but it isn't over yet. We have taken the DB down once for a vacuum analyze
but only vacuum'd 2 large tables which took FIVE HOURS WITH
will do! I'll let you know how it goes but it will be after xmas cause we
can have no down-time right now.
thanks!
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "HT" <[EMAIL PROTECTED]> writes:
>
table users from database "EBPRDS1":
___
3828262123 = users
$ ls -l 3828262123*
-rw--- 1 postgres postgres 1073741824 Dec 18 23:08 3828262123
-rw--- 1 postgres postgres 558899200 Dec 18 23:16 3828262123.1
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTEC
I posted over the
weekend about this issue under the subject of "VACUUM" but the replies I
got did not help. We have several large tables which seem to be taking 4
times as much disk space as they should?
Let me give a little
background:
Every night, we do a
pg_dump of our production
HI
All,
I found the
following posting about Vacuum in the postgres.admin newsgroup (see below my
question)
I have the same
problem: We are using HUGE amounts of diskspace in our production
database, but the standby (created daily from a pgdump / pg_restore of our
production server)
below? Thanks
so much!
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> HT Levine <[EMAIL PROTECTED]> writes:
> > My suspicion is that there are pg_toast_x files left in the base
> > directory?If I
My apologies if this
posted twice...
HI
All,
I found the
following posting about Vacuum in the postgres.admin newsgroup (see below my
question)
I have the same
problem: We are using HUGE amounts of diskspace in our production
database, but the standby (created daily from a pgdump
