On Tue, 8 Jan 2002, Roderick A. Anderson wrote:
> On Tue, 8 Jan 2002, Dave Trombley wrote:
>
> > You can always check exaclty what's being done in your queries by
> > using the EXPLAIN command. For example, to test your hypothesis:
> >
>
> >From your example I'm assuming I don't need data to test the optimizer.
> Cool! This is why I asked (and a little laziness) instead of trying it.
> No real data to populate the table with.
>
> Thanks for the idea/knowledge.
Ah, no that actually isn't true. For example, I believe that Pg will
always Seq Scan a table that has never been vacuum analyzed, or is empty,
or has only a few rows.
-jwb