[BUGS] Selecting from a VIEW is NOT optimized like a similar SELECT statement

2003-11-11 Thread SHADOWPLAY - Dave Adams
POSTGRESQL BUG REPORT TEMPLATE Your name : David B. Adams Your email address : jugular (

[BUGS] RC1 question of reloading data

2003-11-11 Thread Theodore Petrosky
I just downloaded and installed RC1 (7.4) on OSX 10.3. Everything went smoothly for the config. make and install. while reloading the data (from pg_dump in 7.3) I inadvertently screwed up. Or maybe not... my dump file was as1.out so I... psql < as1.out I knew it was wrong the moment after I hi

Re: [BUGS] Selecting from a VIEW is NOT optimized like a similar SELECT statement

2003-11-11 Thread Tom Lane
SHADOWPLAY - Dave Adams <[EMAIL PROTECTED]> writes: > When using a view on a table, a select on the view is not as optimized as > a select directly from the table. PG 7.3 is not very bright about pushing WHERE quals down into a sub-select that involves DISTINCT ON. 7.4 is a tad smarter, and I th