Re: [PERFORM] Overriding the optimizer

2005-12-16 Thread Kyle Cordes
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)--- TIP 9: In versions below 8.0

Re: [PERFORM] Overriding the optimizer

2005-12-16 Thread Kyle Cordes
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 Cordes www.kylecordes.com ---(end

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

2005-11-24 Thread Kyle Cordes
; 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 ---(end of broadcast)--- TIP