PostgreSQL Rising

Post by robe2 » Sun, Jul 22, 2012, 6:58 AM UTC

mgkimsal wrote: post #130

Something that tends to get overlooked in pg/mysql discussions is administration - more specifically account management. all of this is done in the 'mysql' database via SQL directly in mysql ('insert into user', 'grant permission', etc). Most tutorials on PG I've seen over the years show these things being done from the commandline, and assume a unix environment, and an understanding of connecting from various accoun…

Post by erichocean » Mon, Jul 23, 2012, 12:58 AM UTC

atombender wrote: post #166

mgkimsal wrote: post #127

Earlier quoted context omitted.

"... throw serious doubts on the popular myth that count( ) is slow in PostgreSQL." Whew! Glad that was only a myth! I'll remind myself of that whenever my code takes > 10 seconds to return the count( ) from a table. "Just a myth - this isn't really happening". I'll try repeating that to myself while waiting for the results - probably should only take 10-15 repeats of the phrase before the row returns, right? Whoah -…

You can do a fast, conditionless count that ignores current transaction state and therefore risks being slightly out of date, but usually good enough for most use cases: select n_live_tup from pg_stat_user_tables where relname = 'mytable'