[PERFORM] SeqScans on boolen values / How to speed this up?

2010-07-05 Thread Jens Hoffrichter
Hello everyone, We've recently finished developing a bigger webapplication, and we are about to put it online. I ran some load tests yesterday, and configured 'slow query' logging beforehand, so I could see if there might be a performance bottleneck in the PG. While I discovered no real problems,

[PERFORM] Getting rid of a seq scan in query on a large table

2011-06-27 Thread Jens Hoffrichter
Hi everyone, I'm having trouble getting rid of a sequential scan on a table with roughly 120k entries it. Creation of an index on that particular column which triggers the sequential scan doesn't do anything, VACUUM and ANALYZE has been done on the table. The table in question has the following d