Re: [9.1] unusable for large views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [9.1] unusable for large views
Date
Msg-id 1310.1319467581@sss.pgh.pa.us
Whole thread Raw
In response to [9.1] unusable for large views  ("Omar Bettin" <o.bettin@informaticaindustriale.it>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Online base backup from the hot-standby
Next
From: Tom Lane
Date:
Subject: Re: autovacuum and orphaned large objects