> > Are there any good rules of thumb of things one should be looking
> out for in
> > EXPLAIN output? ie <blah> means that an index would be good here
1) Various articles on Techdocs.postgresql.org
2) Ewald G.'s PostgreSQL Book
Explain output is not that easily converted into a plan of action ...
otherwise, Postgres would have automated it, neh? You have to get a
feel for what looks good and bad dynamically.
In response to
pgsql-performance by date
|Next:||From: Mario Weilguni||Date: 2002-10-11 07:14:50|
|Subject: number of attributes in page files?|
|Previous:||From: Bruce Momjian||Date: 2002-10-10 16:44:01|
|Subject: Re: Info on explain output|