Re: [PERFORM] Overriding the optimizer

2005-12-16 Thread Kyle Cordes
d ideally like it to give up right away, not after N seconds of table scanning my 100-million-row tables... and not with a timeout, but with an explicit throwing up of its hands, exasperated, that it could not come up with an efficient way to run my query. Kyle

Re: [PERFORM] Overriding the optimizer

2005-12-16 Thread Kyle Cordes
I'd like to have a few users/operations get a "sorry, I couldn't find a good way to do that" message, rather than all the users find that their system has effectively stopped working. Kyle Cordes www.kylecordes.com ---(end of broadcast)---

Re: [PERFORM] 8.1 count(*) distinct: IndexScan/SeqScan

2005-11-24 Thread Kyle Cordes
y pleased with the PG query planner; it often gets better results than another, popular commercial DBMS we use here that is just a general impression, not the result of setting up the same schema in each for a comparison.) Kyle Cordes www.kylecordes.com -