Am Samstag 04 Dezember 2010 schrieb Tom Lane:
> "Kevin Grittner" writes:
...
> > One option would be to create a different user for running queries
> > which read from complex views such as this.
>
> If you don't want to change the collapse limits, the only other
> option is to restructure this s
Am Samstag 04 Dezember 2010 schrieb Kevin Grittner:
> One option would be to create a different user for running queries
> which read from complex views such as this.
>
> postgres=# create user bob;
> CREATE ROLE
> postgres=# alter user bob set from_collapse_limit = 40;
> ALTER ROLE
> postgres=# a
"Kevin Grittner" writes:
> Markus Schulz 11/24/10 1:02 PM >>>
>> if i set "from_collapse_limit" (to merge the views) and
>> join_collapse_limit (to explode the explicit joins) high enough
>> (approx 32), all is fine (good performance). But other queries are
>> really slow in our environment (ther
Markus Schulz 11/24/10 1:02 PM >>>
> if i set "from_collapse_limit" (to merge the views) and
> join_collapse_limit (to explode the explicit joins) high enough
> (approx 32), all is fine (good performance). But other queries are
> really slow in our environment (therefore it's no option to raise
Am Freitag, 3. Dezember 2010 schrieb Kevin Grittner:
> Markus Schulz wrote:
> > i have a big performance problem
> >
> > [joining two complex views for reporting]
>
> What version of PostgreSQL is this? How is PostgreSQL configured?
> (The postgresql.conf file with all comments removed is good.
Markus Schulz wrote:
> i have a big performance problem
> [joining two complex views for reporting]
What version of PostgreSQL is this? How is PostgreSQL configured?
(The postgresql.conf file with all comments removed is good.)
-Kevin
--
Sent via pgsql-performance mailing list (pgsql-p
hello,
i have a big performance problem with some views which would joined
(from the third party tool crystal reports) to print a document.
view1:
SELECT ...
FROM
personen.kunde kunde,
personen.natuerliche_person person,
viewakteur akteur,
personen.anschrift adresse,
personen.kon
