Re: MySQL million tables

-----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. :)

List of relations
Schema | Name | Type | Owner
- --------+-----------+-------+-------
public | foo1 | table | greg
public | foo10 | table | greg
public | foo100 | table | greg
public | foo1000 | table | greg
public | foo10000 | table | greg
public | foo100000 | table | greg
public | foo100001 | table | greg
public | foo100002 | table | greg
public | foo100003 | table | greg

etc...

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200603100913
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFEEYpuvJuQZxSWSsgRAnXFAKCQD31fIXDvN/2lLl9Unaw0zvAdcgCgkHxh
WsrUkThL+xYz6bdzvZ5jqA4=
=4TZu
-----END PGP SIGNATURE-----