[isf-wifidog] Postgresql and wifidog.

François Proulx fproulx at edito.qc.ca
Sam 21 Jan 01:40:30 EST 2006


oh yeah, I personnaly always do "VACUUM FULL VERBOSE ANALYZE;"


On 20-Jan-2006, at 20:14 , Max Horváth wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I resolved the problem ...
>
> Run VACUUM FULL ANALYZE on your db ...
>
> It'll lock the tables while doing this procedure, but afterwards  
> your server will be fast again ;)
>
> Cheers, Max!
>
>> On January 20, 2006 03:41 pm, Max Horváth wrote:
>>> - gpg control packet
>>> Well,
>>>
>>> I can't imagine it's PHP - but it might be the case ...
>>>
>>> I'll be profiling the code to see where we have a speed bottle  
>>> neck ...
>>>
>>> But right now I think it has to do with PostgreSQL ...
>>>
>>> Benoit, Francios - have you guys any idea?
>>
>> Well, to my knowledge, we've never seen that here.  Max says  
>> Vacuuming had no
>> effect, which is even more puzzling.
>>
>> -- 
>> Benoit Grégoire, http://benoitg.coeus.ca/
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (Darwin)
>
> iD8DBQFD0Yry+BKgC+eQ3ooRAidWAJ935E648QIkwIoD5f+PL9oTjq40rACdE+cM
> QU6qWK9e3ha5DzxWJ8dty2Q=
> =NPaU
> -----END PGP SIGNATURE-----
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog



More information about the WiFiDog mailing list