[Pdns-users] mysql vs postgresql

Norbert Sendetzky norbert at linuxnetworks.de
Mon Feb 5 08:42:45 UTC 2007

Hi Adam

> On a same of 100K zones and using the queryperf tool available with bind
> (selecting each record from each zone) over a 10 minute run, both
> untuned postgresql and mysql was able to handle around 2000 qps.
> After tuning both Postgresql and Mysql, I was able to reach 2500 qps on
> Postgresql however mysql stayed at 2000 qps.

Could you give me more information about your setup? Which distribution and 
with versions of PowerDNS and the databases do you use? Which PowerDNS 
backends were used to connect to the databases and what were the 
optimizations you've done?


OpenPGP public key

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20070205/02f7d69f/attachment-0001.sig>

More information about the Pdns-users mailing list