> Running vacuumdb --full freed the rest of the disk space. Regarding indexes
> from what you said I understand that if I want to free the space used in the
> past by indexes and that isn't freed yet (but it should) I should run
> reindexdb (or reindex in SQL). I did that and another 300MB got freed so
> thank you for both hints,
Here is another link you might find useful.
I found it on this thread. It is an interesting read.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: kmh496||Date: 2006-07-18 14:50:51|
|Subject: why is scan not using index?|
|Previous:||From: Slavisa Garic||Date: 2006-07-18 12:55:39|
|Subject: Re: Disk space taken|