Re: [PERFORM] Set of related slow queries

2011-06-08 Thread John Williams
ifferent game. So I can't help but feel I must be missing something really important either in how I'm setting up my data or how I'm processing. Thanks, John --- John Williams 42nd Design Email: jwilli...@42nddesign.com Skype: druidjaidan Phone: (520) 440-7239 On Wed, Jun 8, 2

[PERFORM] Set of related slow queries

2011-06-08 Thread John Williams
Hi All, I'm having issues with a set of fairly related queries in my application.  EXPLAIN ANALYZE is showing them all to be getting stuck performing roughly the same operation: -> Bitmap Heap Scan on logparser_entry (cost=4119.06..21520.55 rows=68787 width=8) (actual time=107.032..