Greg Smith questions

Greg Smith answers

• IN statement performance in PostgreSQL (and in general)
• Is there a way to upgrade from a Heroku shared database to a production grade database like Basic or Crane?
• How can I use an index on a partitioned table in postgresql 8.3.7
• Is MySQL appropriate for a read-heavy database with 3.5m+ rows? If so, which engine?
• Does the order of tables in a join matter, when LEFT (outer) joins are used?
• Any difference in the way a primary key is defined in Postgres?
• How to connect to a PostgreSQL server via JDBC in Android?
• Identifying a connection ID in Postgres
• Speed of IN keyword in MySQL/PostgreSQL
• Does setting "NOT NULL" on a column in postgresql increase performance?