Re: 7.3.1 New install, large queries are slow - Mailing list pgsql-performance

From Tomasz Myrta
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id 3E12BBEA.5020105@klaster.net
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  ("Roman Fail" <rfail@posportal.com>)
List pgsql-performance
Roman Fail wrote:
> The same result columns and JOINS are performed all day with variations on the WHERE clause;
Are there any where clauses which all of theses variation have?
If yes - query can be reordered to contain explicit joins for these clauses and
to let Postgres to find best solution for other joins.

I know, it is not best solution, but sometimes I prefer finding best join order by myself.
I create then several views returning the same values, but manualy ordered for specific where clauses.

Tomasz Myrta



pgsql-performance by date:

Previous
From: "Roman Fail"
Date:
Subject: Re: 7.3.1 New install, large queries are slow
Next
From: Kevin Brown
Date:
Subject: Re: 7.3.1 New install, large queries are slow