Hello
please, send a result of explain analyze on 9.1.1 and older
please, use http://explain.depesz.com/
Regards
Pavel Stehule
2011/10/24 Omar Bettin :
> Hello,
>
>
>
> I have tried 9.1.1 win64 version and when I am trying to declare a cursor
> for a very large view (lot of joins and aggregate
2011/10/24 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
>
attachment is missing
Pavel
>
>>Hmm. A 59-table join is pretty enormous
>
> an
...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.
--
S
On 24/10/11 10:57, Omar Bettin wrote:
>
> [monster query]
I see that your problem is already solved, but incidentially I'm working
on a join order planning module and I'm looking for real-life examples
of humongous queries like that to benchmark against them.
Any chance you could share the schem
"Omar Bettin" writes:
> I have tried 9.1.1 win64 version and when I am trying to declare a cursor
> for a very large view (lot of joins and aggregate functions),
> postgres is using around 3GB of memory and the query never returns.
Could we see a self-contained test case? I'm not about to try t
everyone.
Regards,
Omar
-Messaggio originale-
Da: Tom Lane [mailto:t...@sss.pgh.pa.us]
Inviato: lunedì 24 ottobre 2011 16:46
A: Omar Bettin
Cc: pgsql-hackers@postgresql.org
Oggetto: Re: [HACKERS] [9.1] unusable for large views
"Omar Bettin" writes:
> I have tried 9.1.1 win6
-hackers@postgresql.org
Oggetto: Re: [HACKERS] [9.1] unusable for large views
Hello
please, send a result of explain analyze on 9.1.1 and older
please, use http://explain.depesz.com/
Regards
Pavel Stehule
2011/10/24 Omar Bettin :
> Hello,
>
>
>
> I have tried 9.1.1 win64 version and w
On Mon, Oct 24, 2011 at 4:57 AM, Omar Bettin
wrote:
> I have tried 9.1.1 win64 version and when I am trying to declare a cursor
> for a very large view (lot of joins and aggregate functions),
>
> postgres is using around 3GB of memory and the query never returns.
Hmm. A 59-table join is pretty e