Hi all,
each time that someone say: this query is slow, this query take forever, bla
bla bla
all our request are:
1) Which version are you running ?
2) May I see your table definition?
3) May I see you configuration file?
4) May I see the explain ?
5) .......
sometimes a beginner is scared about all these questions and even
he/she don't know how do collect these informations and we lose
important data about: "why that damn query is too slow"?
may be is usefull generate an automatic report that take charge
of collect all these informations and send it to a file or directly to
pgsql-performance@postgresql.org , may be something like:
> BEGIN REPORT TO FILE <file_name>
> SELECT ......
> END REPORT;
or
> BEGIN REPORT TO EMAIL <address>
> SELECT ......
> END REPORT;
Regards
Gaetano Mendola