On Fri, Oct 17, 2008 at 4:31 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: > non-existent and/or improper DB design can impede your progress > > You'll need to get stats pack configured, run explain plain on your selects > to > determine which columns you will to need to index..
I think you're confusing oracle and pgsql a bit there. But yeah, he needs to get all the stats collection stuff running and he should consider a migration to 8.3 if he's not already there. At least 8.2 where current_query in the pg_stats_activity table is very cheap and can be turned on without slowing down an already slow server. -- When fascism comes to America, it will be draped in a flag and carrying a cross - Sinclair Lewis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
