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

From: "Omar Bettin" <o(dot)bettin(at)informaticaindustriale(dot)it>
To: "'Robert Haas'" <robertmhaas(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: R: [9.1] unusable for large views (SOLVED)
Date: 2011-10-24 14:29:37
Message-ID: 006e01cc9259$5f7c5470$1e74fd50$@bettin@informaticaindustriale.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

...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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-10-24 14:36:55 Re: autovacuum and orphaned large objects
Previous Message Euler Taveira de Oliveira 2011-10-24 14:25:16 Re: autovacuum and orphaned large objects