Re: MySQL million tables

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: MySQL million tables
Дата
Msg-id 36e682920603082301ia2b3bceq8517c584a47dd61b@mail.gmail.com
обсуждение исходный текст
Ответ на MySQL million tables  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: MySQL million tables  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-advocacy
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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: PostgreSQL committer history?
Следующее
От: "Stefan 'Kaishakunin' Schumacher"
Дата:
Сообщение: Re: MySQL million tables