Re: [GENERAL] Interpreting statistics collector output

an show up in the web page, making the tuning process a little less painful. (The plugins project home page is at http://groups.google.com/group/ pgsql_stats.) -- Steve Madsen <[EMAIL PROTECTED]> Light Year Software, LLC http://lightyearsoftware.com ZingLists:

Re: [GENERAL] Interpreting statistics collector output

relative to the number of rows in the table, wouldn't that imply that those sequential scans are often returning most of the rows in the table? In that case, would an index help much or is a sequential scan the expected result? -- Steve Madsen <[EMAIL PROTECTED]> Light Year So

[GENERAL] Interpreting statistics collector output

re easy to compute, but is this useful beyond knowing if Postgres has enough buffers? Can anything useful be gleaned from looking at idx_scan / idx_tup_read / idx_tup_fetch? -- Steve Madsen <[EMAIL PROTECTED]> Light Year Software, LLC http://lightyearsoftware.com ZingLists: Stay orga