Postgres Pro
Downloads
Home   >   mailing lists

Re: MySQL million tables - Mailing list pgsql-advocacy

From Jonah H. Harris
Subject Re: MySQL million tables
Date
Msg-id 36e682920603082301ia2b3bceq8517c584a47dd61b@mail.gmail.com
Whole thread Raw
In response to MySQL million tables  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: MySQL million tables  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-advocacy
Tree view
On 3/9/06, Christopher Kings-Lynne <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

pgsql-advocacy by date:

Previous
From: Neil Conway
Date:
Subject: Re: PostgreSQL committer history?
Next
From: "Stefan 'Kaishakunin' Schumacher"
Date:
Subject: Re: MySQL million tables