Quick question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Quick question
Date: 2003-09-09 03:02:18
Message-ID: 200309082002.18830.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

Back in the 7.0 days,

WHERE EXISTS (SELECT * FROM a WHERE condition)

was significantly slower on broad tables than

WHERE EXISTS (SELECT small_col FROM a WHERE condition)

Is this still true, or something that's been fixed in the last 3 versions?
Joe Celko is making fun of me because Oracle doesn't have this performance
issue.

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-09-09 03:14:29 Re: Quick question
Previous Message Tom Lane 2003-09-09 02:21:26 Re: slow plan for min/max