On October 9th, 2007 Anonymous (not verified) says:
Pg is faster until you do some deletes ... then the vacuum job kicks in and perf goes to hell. If its a busy server with a lot of inserts and deletes the vacuum job might not even be able to finish. If that happens you have to take the DB offline for maint.
Pg is great but overall isn't faster than mysql ... yet!
Vacuum
Pg is faster until you do some deletes ... then the vacuum job kicks in and perf goes to hell. If its a busy server with a lot of inserts and deletes the vacuum job might not even be able to finish. If that happens you have to take the DB offline for maint.
Pg is great but overall isn't faster than mysql ... yet!