Hello Michael,
Here is the information : I had executed explain analyze with modified
FROM clause.
Oops forgot to mention the version earlier.
Using postgres 8.0.0 on Solaris 9.
Rows Count :
cic=# select count(*) from taxpack_user;
count
172645
(1 row)
cic=# select count(*) from ec
On Wed, 9 Nov 2005, Ashok Agrawal wrote:
> I noticed outer join is very very slow in postgresql as compared
> to Oracle.
>
> SELECT a.dln_code, a.company_name,
> to_char(a.certificate_date,'DD-MON-'),
> to_char(a.certificate_type_id, '99'),
> COALESCE(b.certificate_type_description,'None') ,
>
Ashok Agrawal <[EMAIL PROTECTED]> writes:
> I noticed outer join is very very slow in postgresql as compared
> to Oracle.
I think the three things the people best able to help you are going to
ask for are 1) what version of PostgreSQL, 2) what are the tables, and
how many rows in each, and 3) outp
I noticed outer join is very very slow in postgresql as compared
to Oracle.
SELECT a.dln_code, a.company_name,
to_char(a.certificate_date,'DD-MON-'),
to_char(a.certificate_type_id, '99'),
COALESCE(b.certificate_type_description,'None') ,
a.description, a.blanket_single, a.certificate_status,
C
