From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) |
Cc: | jim(at)reptiles(dot)org, gjerde(at)icebox(dot)org, gd(at)pinmail(dot)com, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Large database |
Date: | 1999-08-17 17:16:50 |
Message-ID: | m11Gmqw-00080YC@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > it would be nice if vacuum could figure out if an extent is no longer
> > in use, and delete it.
> >
> > currently, we need to dump the table, then nuke it and restore it.
>
> We tried removing the extra extent, but the other backends needed it
> around because there was no way to tell them that the extra extent file
> descriptor was useless. You could just stop the postmaster, and delete
> the zero-length extents, if you really wanted to. Do the extra extent
> files cause problems for you? If so, we can start to look at some
> postmaster cleanup of those.
i haven't actually seen the system reduce a numbered extent.
i could be wrong.
--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-08-17 17:19:52 | Re: [GENERAL] Large database |
Previous Message | Bruce Momjian | 1999-08-17 17:03:54 | Re: [GENERAL] Large database |