Re: 7.3.1 New install, large queries are slow

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Roman Fail <rfail(at)posportal(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7.3.1 New install, large queries are slow
Date: 2003-01-01 09:59:06
Message-ID: 3E12BBEA.5020105@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-01-01 21:01:13 Re: preliminary testing, two very slow situations...
Previous Message Ron Johnson 2003-01-01 08:14:34 Re: alter table TBL add constraint TBL_FK foreign key