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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Omar Bettin <o(dot)bettin(at)informaticaindustriale(dot)it>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [9.1] unusable for large views (SOLVED)
Date: 2011-10-24 17:02:44
Message-ID: CAFj8pRCJvP5ZE7C9DS8fpyq1mKAF0Wg2C+PC+DYRdeB5dzEoFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/10/24 Omar Bettin <o(dot)bettin(at)informaticaindustriale(dot)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 enormous
>
> and is not the biggest, basically are delivery notes for one day seen in
> vertical.
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-10-24 17:05:55 Re: Unreproducible bug in snapshot import code
Previous Message Gurjeet Singh 2011-10-24 16:55:44 Unreproducible bug in snapshot import code