On Sat, Nov 02, 2002 at 08:20:04PM -0500, Bruce Momjian wrote:
Alexander M. Pravking wrote:
As I see, contrib/reindexdb requires perl for commandline
procesing. I don't think it's a good idea, since
e.g. FreeBSD 5.0-CURRENT have no perl in standard distribution.
Thomas, why not to use
On Fri, Nov 01, 2002 at 10:48:00PM -0500, Bruce Momjian wrote:
Tim, I guess your problem is dead index pages that can't be reclaimed,
and it isn't fixed in 7.3. Only REINDEX fixes it, and we have a
/contrib/reindexdb script in 7.3.
As I see, contrib/reindexdb requires perl for commandline
Alexander M. Pravking wrote:
On Fri, Nov 01, 2002 at 10:48:00PM -0500, Bruce Momjian wrote:
Tim, I guess your problem is dead index pages that can't be reclaimed,
and it isn't fixed in 7.3. Only REINDEX fixes it, and we have a
/contrib/reindexdb script in 7.3.
As I see,
Hi, in my production server a "du -hs" in the DATA
directory
returns 21GB
in a newly installed server, after I restored the
dumps from the
production server, the "du -hs" gives me just
8GB
why is there such a diference???
what should I do (besides buying bigger and bigger
HDs) ???
[]'s
Hi, in my production server a du -hs in the DATA directory
returns 21GB
in a newly installed server, after I restored the dumps from the
production server, the du -hs gives me just 8GB
why is there such a diference???
what should I do (besides buying bigger and bigger HDs) ???
VACUUM?
I do daily vacuums on the production server
| Hi, in my production server a du -hs in the DATA directory
| returns 21GB
| in a newly installed server, after I restored the dumps from the
| production server, the du -hs gives me just 8GB
|
| why is there such a diference???
|
| what
On Fri, 1 Nov 2002, [iso-8859-1] Maurício Sessue Otta wrote:
I do daily vacuums on the production server
You haven't said what version you're running, but if you're
using 7.2 and non-FULL vacuums you also will want to make sure
that you have the free space map settings in postgresql.conf
are
Maurício Sessue Otta wrote:
Hi, in my production server a du -hs in the DATA directory
returns 21GB
in a newly installed server, after I restored the dumps from the
production server, the du -hs gives me just 8GB
why is there such a diference???
what should I do (besides buying bigger and