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 everyone.
Regards,
Omar
-----Messaggio originale-----
Da: Tom Lane [mailto:tgl@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" <o.bettin@informaticaindustriale.it> 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 to
reverse-engineer the schema that goes with such a monster query.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
regards, tom lane