Re: MySQL million tables - Mailing list pgsql-advocacy

-----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@turnstep.com
PGP Key: 0x14964AC8 200603100913
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

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

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