Re: MySQL million tables - Mailing list pgsql-advocacy

From Richard Huxton
Subject Re: MySQL million tables
Date
Msg-id 4411BB58.8010406@archonet.com
Whole thread Raw
In response to Re: MySQL million tables  ("Greg Sabino Mullane" <greg@turnstep.com>)
List 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

pgsql-advocacy by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: MySQL million tables
Next
From: Jim Nasby
Date:
Subject: Re: MySQL million tables