Created
August 6, 2012 16:21
-
-
Save grigio/3276129 to your computer and use it in GitHub Desktop.
How does the 14000 rows limitation work on heroku?
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
➜ myapp git:(master) heroku pg:psql | |
psql (9.1.3, server 9.1.4) | |
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) | |
Type "help" for help. | |
d7342gd34r=> | |
d7342gd34r=> select count(*) from coords; | |
count | |
-------- | |
188980 | |
(1 row) | |
d7342gd34r=> select (id, desc | |
d7342gd34r=> select (id, description) from coords order by id desc limit 5; | |
row | |
---------------------------- | |
(1916640,test) | |
(1916639,test) | |
(190000,"article #190000") | |
(189999,"article #189999") | |
(189998,"article #189998") | |
(5 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
SELECT sum(reltuples) from pg_class where relname IN (c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'r'nformation_schema' AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema'd)); AND n.nspname !~ '^pg_toast' AND pg_catalog.pg_table_is_visible(c.oid));