Re: MySQL million tables
От
Jonah H. Harris
Тема
Re: MySQL million tables
Дата
Msg-id
36e682920603082348v6f8e255bx6f8010e0833eb67a@mail.gmail.com
Ответ на
Re: MySQL million tables (Stefan 'Kaishakunin' Schumacher)
Список
Дерево обсуждения
Re: MySQL million tables Christopher Browne <cbbrowne@acm.org>
Re: MySQL million tables Jim Nasby <jim@nasby.net>
Re: MySQL million tables Robert Treat <xzilla@users.sourceforge.net>
Re: MySQL million tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: MySQL million tables Chris <dmagick@gmail.com>
Re: MySQL million tables "Joshua D. Drake" <jd@commandprompt.com>
Re: MySQL million tables "Guido Barosio" <gbarosio@gmail.com>
On 3/9/06, Stefan 'Kaishakunin' Schumacher <stefan@net-tex.de> wrote:
My results were based on 500 CREATE TABLE's per transaction, so my results aren't comparable either.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324
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
My results were based on 500 CREATE TABLE's per transaction, so my results aren't comparable either.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324
В списке pgsql-advocacy по дате отправления
