Re: [PERFORM] Planner doesn't chose Index - (slow select)

2006-04-19 Thread patrick keshishian
Tom, You are absolutely correct about not having run ANALYZE on the particular table. In my attempt to create a simple "test case" I created that table (pk_c2) from the original and had not run ANALYZE on it, even though, ANALYZE had been run prior to building that table. The problem on the test

Re: [PERFORM] Planner doesn't chose Index - (slow select)

2006-04-18 Thread Tom Lane
"patrick keshishian" <[EMAIL PROTECTED]> writes: > I've been struggling with some performance issues with certain > SQL queries. I was prepping a long-ish overview of my problem > to submit, but I think I'll start out with a simple case of the > problem first, hopefully answers I receive will help

[PERFORM] Planner doesn't chose Index - (slow select)

2006-04-18 Thread patrick keshishian
Hi all, I've been struggling with some performance issues with certain SQL queries. I was prepping a long-ish overview of my problem to submit, but I think I'll start out with a simple case of the problem first, hopefully answers I receive will help me solve my initial issue. Consider the follow