On 11.07.2007, at 15:29, Miguel Arroz wrote:

Is this normal? Is the order random? What's happening here? I'm asking this, because from what I understand form the PostgreSQL docs, the order of the stuff in ANDs (and ORs) may have cause a really big difference in performance when indexes (and multi- indexes) are envolved.

I can make big differences. I normally avoid multicolumn indexes in PostgreSQL as it can combine single column indexes quite efficiently.

So, I normally don't worry about that, only in really special cases.

Nevertheless: you could file a bug.

cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to