Another mysql blogger has chimed in now:
http://arjen-lentz.livejournal.com/66547.html
He did it with MyISAM tables though.
Chris
Jonah H. Harris wrote:
> On 3/9/06, *Christopher Kings-Lynne* <chriskl@familyhealth.com.au
> <mailto:chriskl@familyhealth.com.au>> wrote:
>
> Also, can we beat his estimate of 27 hours for creation?
>
>
> I just tried it on my a Thinkpad:(Pentium M @ 1.73GHz) running SuSE 10
> and an untuned PostgreSQL 8.1.3 using a shell script and psql. I was
> able to create 274,000 tables in exactly 798 seconds.
>
> And it's still chugging away :)
>
>
> Chris
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
>
> --
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> 732.331.1324