ion performance? Is there an optimization I am
missing?
Ryan
> On Wed, 22 Feb 2006, ryan groth wrote:
>
> > Does this work:
> >
> > "Merge Left Join (cost=0.00..2656.36 rows=6528 width=1522) (actual
> > time=0.057..123.659 rows=6528 loops=1)"
> >
; Index Scan using useraux_pkey on useraux (cost=0.00..846.40
> rows=7582 width=262) (actual time=0.007..11.935 rows=7529 loops=1)"
> "Total runtime: 127.442 ms"
>
>
> > On Wed, Feb 22, 2006 at 12:26:47PM -0500, ryan groth wrote:
> > > Postgres Explain
&
Scan using phorum_users_base_pkey on
phorum_users_base (cost=0.00..822.92 rows=9902 width=1168) (actual
time=0.007..15.674 rows=9845 loops=1)"
" -> Index Scan using useraux_pkey on useraux (cost=0.00..846.40
rows=7582 width=262) (actual time=0.007..11.935 rows=7529 loops=1)"
&quo
I am issing a query like this:
SELECT *
FROM users users
LEFT JOIN phorum_users_base ON users.uid = phorum_users_base.user_id
LEFT JOIN useraux ON useraux.uid = users.uid;
The joins are all on the PKs of the tables. It takes 1000ms to run on
postgres. The identical mysql version runs in 2
