Explain Analyze help

From: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Explain Analyze help
Date: 2004-03-09 22:48:42
Message-ID: E9DB5A93-721B-11D8-A00B-000A9579AF50@indeq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've just completed my application and my customer is starting to
populate the database. I've put a table in where queries get logged so
that I can start pinpointing my optimizations to the most frequently
used queries. I've read the manual on the explain analyze statement
and I have one (which will probably turn into many) question.

Obivously, I have a lot of sequential scans going on, at about what
cost does it start to make sense to make an index? Or, should I just
put in a bunch of indexes and let the optimizer decide whether or not
to use them?

OK, so it was 2 questions.

Anyone? Bueller?

Mark

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2004-03-09 23:44:11 Re: Cygwin - Cygnus for Windows - Linux based portedto Windows
Previous Message scott.marlowe 2004-03-09 22:12:01 Re: postgres on apple OS X server