I am in the process of adding PostgreSQL support for an application,
in addition to Oracle and MS SQL.
I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III
board.
I have a query that generally looks like this:
SELECT t1.col1, t2.col1 FROM t1, t2 WHERE t1.x=t2.y AND t2.p='str
.
Martijn van Oosterhout wrote:
Please supply EXPLAIN ANALYZE output.
On Sun, Oct 26, 2003 at 12:25:37AM +0300, Yonatan Goraly wrote:
I am in the process of adding PostgreSQL support for an application, in
addition to Oracle and MS SQL.
I am using PostgreSQL version 7.3.2, Red Hat
yes
Alvaro Herrera wrote:
On Mon, Oct 27, 2003 at 12:08:31AM +0200, Yonatan Goraly wrote:
I have a query that uses the same view 6 times. It seems that the
database engine is calculating the view each time.
The result is very poor performance. The same query takes 2 sec with MS
SQL, and
