anse1 / sqlsmith

A random SQL query generator
GNU General Public License v3.0
722 stars 123 forks source link

Multithreading #9

Open anse1 opened 7 years ago

anse1 commented 7 years ago

Starting multiple sqlsmith processes targeting the same database is inefficient because they each generate a redundant read-only schema object, wasting memory and clobbering caches.

The grammar generation would also profit from running in its own thread to avoid blocking while the DUT is busy.

NikParam42 commented 4 years ago

@anse1 Do I understand correctly that to run SQL smith in parallel, it is enough to run it for different databases in postgres?