Re: MySQL million tables

From: Richard Huxton <dev(at)archonet(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: MySQL million tables
Date: 2006-03-10 17:46:00
Message-ID: 4411BB58.8010406@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>>> greg=# select count(*) from pg_class where relkind='r' and relname ~ 'foo'
>>> count
>>> - ---------
>>> 1000000
>
>> Try \dt :D
>
> Sure. Took 42 seconds, but it showed up just fine. :)

The real test is to put a few rows into each, join the lot and see how
long it takes geqo to plan it.

Actually, if that works the real test is to find a use for this :-)

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Jim Nasby 2006-03-11 00:17:11 Re: MySQL million tables
Previous Message Greg Sabino Mullane 2006-03-10 14:23:07 Re: MySQL million tables