Re: [SQL] Capacity planning.

2010-04-01 Thread Brad Nicholson
urrent access, or is it distributed? -what is the expected cache hit ratio? -what is the expected data size? What is the expected growth rate? -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes t

Re: [SQL] finding unused indexes?

2006-08-01 Thread Brad Nicholson
On Tue, 2006-08-01 at 09:05 -0700, George Pavlov wrote: > Anybody have a clever way to quickly find whether there are any unused > indexes in a PG DB? One way I have done is to take queries from the DB > log, prepend an explain to each and grep the results, but I am wondering > if there are either