On 2 Mar 2014, at 1:48pm, Elefterios Stamatogiannakis <est...@gmail.com> wrote:
> IMHO, a benchmark like this is useless without any more information. Some > questions that i would like to see answered: > > - Which SQLite and Postgres versions were used? > - Are the SQLite indexes, covering ones? > - Have any performance pragmas being used? Does Postgres have enough memory assigned that it's caching the entire database in memory ? What journal mode is SQLite running in ? What page sizes are both systems using ? How many processors does the computer have (i.e. is the Postgres server process using the same process as the app) ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users