Re: SQL compatibility reminder: MySQL vs PostgreSQL

On 2010-03-08 11:17 +0200, Pierre C wrote:
> - index skip scans (well, MySQL doesn't really do index skip scans, but  
> since it can do index-only scans, it's an approximation)

As far as I can tell, we already do index skip scans:

=> create index foo_a_b_idx on foo(a,b);
CREATE INDEX

=> explain analyze select * from foo where b = 2;
                                               QUERY PLAN
---------------------------------------------------------------------------Index Scan using foo_a_b_idx on foo
(cost=0.00..20.30rows=5 width=8)
 
(actual time=0.027..0.057 rows=1 loops=1)  Index Cond: (b = 2)Total runtime: 0.075 ms
(3 rows)


Regards,
Marko Tiikkaja