[BUGS] Is this planner choice easily explained?

2002-11-21 Thread Philip Warner
This is a summary from a thread on the dbmail mailing list. I am trying to understand some apparently odd behaviour with 7.2.1 and 7.2.3. Adding a LIMIT statement causes what seems like a very bad choice of strategy. The first statement is fine: explain SELECT messageblk FROM messageblks W

Re: [BUGS] Is this planner choice easily explained?

2002-11-21 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > I am trying to understand some apparently odd behaviour with 7.2.1 and > 7.2.3. Adding a LIMIT statement causes what seems like a very bad choice of > strategy. The first statement is fine: Could we see the pg_stats rows for the columns used in these q