PostgreSQL 8.1 vs. SQLite 3.6.20 in the real application
For testing is used the production PostgreSQL database. I did build SQLite database as described here: Trigger-based PostgreSQL to SQLite online replication The test requests is real queries from the production system. The PostgreSQL is too slow on these queries and I search more performance database system for the intranet/internet portal. All tables have needed indices. Some tables are renamed in SQLite database but their names and fields names are similar. Note The PostgreSQL quries is rewrited for better index usage but SQLite query planner work fine without any additional tricks. The query conditions are generated by application query builder for user filters and settings and when you can see identical conditions these are not always identical. Hardware Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz MemTotal: 8310900 kB HDD: 1 VelociRaptor 10000 rpm PostgreSQL parameters work_mem = 100000 # min 64, size in KB maintenance_work_mem = 2000000 # mi