On Fri, Sep 21, 2012 at 7:32 AM, salah jubeh <s_jubeh@xxxxxxxxx> wrote: > Hello, > > I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, > both are fresh installs and both has the same configuration files and > databases. > > I am running queries sequentially on each machine using a database dumped > from a life server , and 9.1 server is much slower than 8.4. > > I am wondering what might be the cause for this behaviour? Does 9.1 > requires more attention on setting some parameters .. ? At this level of detail, it is impossible to give an answer. Some people will find 9.1 faster, some slower. I suspect more will find it faster than slower. Can you provide an easily reproducible test case? Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general