Re: MySQL million tables - Mailing list pgsql-advocacy

Also sprach Christopher Kings-Lynne (chriskl@familyhealth.com.au)
> I see in this post on planetmysql.org that this guy got MySQL to die
> after creating 250k tables.  Anyone want to see how far PostgreSQL can
> go? :)
>
> http://bobfield.blogspot.com/2006/03/million-tables.html
>
> Also, can we beat his estimate of 27 hours for creation?

for i in `seq 1 1000000`;
do
echo "create table test$i (ts timestamp);"|psql tabletorture;
done