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.