What about the indexes?
With postgres the VACUUM doesn't work on indexes and with a much smaller
database (as follow)
Database statistics
Status Expired Total
-----------------------------
200 0 3876 OK
301 0 6 Moved Permanently
401 0 86 Unauthorized
403 0 1 Forbidden
404 0 8 Not found
-----------------------------
Total 0 3977
the mnogosearch database grew up to 16G... so anytime the indexer work
from scratch DROP and CREATE INDEXes is a good idea!
ciao
chiara
On Thu, 2002-05-23 at 18:04, [EMAIL PROTECTED] wrote:
> Author: Lorenzo
> Email: [EMAIL PROTECTED]
> Message:
> Hi
> i have a little disk space problem, my mnogosearch version is 3.1.19, mysql 3.23.46,
>a server table with 92 record, my statistics is:
>
> [root@db sbin]# ./indexer -S
>
> Database statistics
>
> Status Expired Total
> -----------------------------
> 200 65 296007 OK
> 301 0 105 Moved Permanently
> 302 0 1567 Moved Temporarily
> 304 5 39057 Not Modified
> 400 0 206 Bad Request
> 401 0 22 Unauthorized
> 403 0 341 Forbidden
> 404 48 6522 Not found
> 500 0 194 Internal Server Error
> 503 0 29 Service Unavailable
> 504 0 5952 Gateway Timeout
> -----------------------------
> Total 118 350002
>
> and my disk space:
>
> [root@db sbin]# du -h /var/lib/mysql/mnogosearch/
> 4.6G /var/lib/mysql/mnogosearch
>
> there are something wrong?
> Thank you
> Lorenzo
>
> Reply: <http://www.mnogosearch.org/board/message.php?id=4873>
>
> ___________________________________________
> If you want to unsubscribe send "unsubscribe general"
> to [EMAIL PROTECTED]
>
--
--
[EMAIL PROTECTED]
"Oltre le illusioni di Timbuct� e le
gambe lunghe di Babal� c'era
questa strada...Questa strada zitta
che vola via come una farfalla, una
nostalgia, nostalgia al gusto di
cura�ao...Forse un giorno meglio
mi spiegher�"
(Paolo Conte, "Hemingway")
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
