| 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: | Whole Thread | Raw Message | 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
| 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 |