2012/2/23 Dmytrii Nagirniak <dnagir@xxxxxxxxx>: > On 23/02/2012, at 5:05 PM, Pavel Stehule wrote: > >> SQLite should be faster in single user test - it is optimized for this >> purpose. So you cannot to get same speed from PostgreSQL > > That's unfortunate to hear. > But hoped with a bit of tuning to get PG close to SQLite by the fact that I can change the settings in such a way so it runs more like a single user DB. It depends on test queries and data set size - but with simple queries and small dataset SQLite should be 2x - 10x faster than PostgreSQL. PostgreSQL is optimized for complex queries and multi user environment Pavel > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
