R: [HACKERS] [9.1] unusable for large views (SOLVED)

2011-10-24 Thread Omar Bettin
...sorry guys... was a misconfiguration of database. 9.1.1 is working good. is ~4% faster than 9.0.5 for same query. Thanks a lot. Regards -Messaggio originale- Da: Pavel Stehule [mailto:pavel.steh...@gmail.com] Inviato: lunedì 24 ottobre 2011 12:13 A: Omar Bettin Cc:

R: [HACKERS] [9.1] unusable for large views (SOLVED)

2011-10-24 Thread Omar Bettin
Hi Tom, ...are about two hours I am trying to communicate that the problem has been solved, but I do not see the messages in the mailing list... Anyway, the problems was a bad installation of database (pgsql functions). 9.1.1 is working good. is 4% to 8% faster than 9.0.5. Thanks a lot to

R: [HACKERS] [9.1] unusable for large views (SOLVED)

2011-10-24 Thread Omar Bettin
...sorry guys... was a bad configuration of database. 9.1.1 is working good. is 4% to 8% faster than 9.0.5. Thanks a lot. Regards Omar P.s. attached EXPLAIN Hmm. A 59-table join is pretty enormous and is not the biggest, basically are delivery notes for one day seen in vertical. --

Re: [HACKERS] [9.1] unusable for large views (SOLVED)

2011-10-24 Thread Pavel Stehule
2011/10/24 Omar Bettin o.bet...@informaticaindustriale.it: ...sorry guys... was a bad configuration of database. 9.1.1 is working good. is 4% to 8% faster than 9.0.5. Thanks a lot. Regards Omar P.s. attached EXPLAIN attachment is missing Pavel Hmm.  A 59-table join is pretty