Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Andrew - Supernews wrote:
>> Perhaps you missed the fact that the query was not one that he wrote,
>> but is the query that psql uses for \ds ?
> I did miss that. Perhaps with dependency tracking and all, we don't
> need the left joins anymore?
I don't see anything wrong with leaving the left joins as-is, on the
1. the planner can simplify the left joins to inner joins, eg the
join to pg_namespace should be simplified on the strength of the
test on nspname. (This seems to be broken in HEAD, but it does
work in 8.1 --- I think I broke it with the changes to treat IN
as a ScalarArrayOp. Will fix.)
2. HEAD also knows how to change the order of the left joins at need.
The real question to me is why the planner doesn't want to use the
index on pg_authid.oid. That's pretty curious ...
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Scott Marlowe||Date: 2006-02-06 18:37:53|
|Subject: Re: autovacuum|
|Previous:||From: James William Pye||Date: 2006-02-06 18:25:05|
|Subject: Re: Copy From & Insert UNLESS|
pgsql-patches by date
|Next:||From: Stephen Frost||Date: 2006-02-06 18:55:20|
|Subject: Re: [HACKERS] Krb5 & multiple DB connections|
|Previous:||From: Peter Eisentraut||Date: 2006-02-06 17:21:46|
|Subject: Re: slow information schema with thausand users, seq.scan pg_authid|