> -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Kees Jongenburger > Verzonden: donderdag 23 juni 2005 19:43 > Aan: Discussion list for developers > Onderwerp: Re: [Developers] query plan optimization > > > On 6/23/05, Ernst Bunders <[EMAIL PROTECTED]> wrote: > > hello > > > > I have a question. I am using cloud context security in one of hour > > websites, and i run into the problem that the dbms > (postgresql) makes > > an unfortunate queryplan. In stead of starting with finding > the right > > film node, it first finds all the film nodes that comply with the > > security constraint in the where clouse. Is there a way to > influence > > this behavour? > Have you tried posting this to the postgress mailing list? >
no, might be a good idear > The query planner takes amount of data into account. did you > perform a > vacuum analyze? yes, the database is treated like that every night. thanks, ERnst > _______________________________________________ > Developers mailing list > [email protected] > http://lists.mmbase.org/mailman/listinfo/developers > _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
