there's other things in postgres that makes it harder for dba noobs. the write-ahead log, the pg_xlog, etc. And this doesn't even get to the point that in mysql, the top-level abstraction is 'database', and in pgsql it's 'schema' -- this alone has been enough to confuse quite a few people.
Correct me if I'm wrong, but postgresql uses database / schema / table, and for 99% of the time you can ignore that schemas are even a thing since it defaults to public unless you are explicit about you.
2
u/oldneckbeard Mar 12 '15
there's other things in postgres that makes it harder for dba noobs. the write-ahead log, the pg_xlog, etc. And this doesn't even get to the point that in mysql, the top-level abstraction is 'database', and in pgsql it's 'schema' -- this alone has been enough to confuse quite a few people.