Greg Smith questions

Greg Smith answers

• 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?
• how to make several plots from the same standard input data in gnuplot?
• Event Scheduler in PostgreSQL?