Re: getting count for a specific querry

I have asked specific questions and paid attention to the various threads on
configuration.

I will take my config files and post on the performance thread that is a
good suggestion (personnaly I have more faith in this forum then a paid
consultant, but at this point I am willing to try both).

Thanks again.

The count thing I can get around using stored results and on demand
counting, but some of my statistical reporting is just a must have.

I enclosed one of my views, I realize to get help I should also include
tables and indexes etc, and maybe I will do that.

It is just there are so many of them. This one in particular did not run at
all when I first got my data loaded.

I ended up adding a few indexes and not sure what else and got it to run
faster on postgres.

Now it is running horrid, so I am back to the drawing board I change one
thing and something else breaks.

I am just frustrated, maybe Monday I will have better strength to figure it
all out.

Joel Fradkin