Re: [HACKERS] [9.1] unusable for large views

2011-10-24 Thread Pavel Stehule
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

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

2011-10-24 Thread Pavel Stehule
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

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

Re: [HACKERS] [9.1] unusable for large views

2011-10-24 Thread Jan Urbański
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

Re: [HACKERS] [9.1] unusable for large views

2011-10-24 Thread Tom Lane
"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

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

2011-10-24 Thread Omar Bettin
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

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

2011-10-24 Thread Omar Bettin
-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

Re: [HACKERS] [9.1] unusable for large views

2011-10-24 Thread Robert Haas
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