| From: | "andremachado" <andremachado(at)techforce(dot)com(dot)br> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | firebird X postgresql 8.1.2 windows, performance comparison |
| Date: | 2006-03-14 18:33:20 |
| Message-ID: | 20060314183226.M29726@techforce.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
Many thanks for your suggestions.
I am trying to optimize server configs, as (presumed) my friend already
optimized his queries and firebird windows is executing them fast.
You could see at the new attached file the results of the queries rewrite.
Unfortunately, the first query simply returned the same estimated costs by the
planner.
The second one, using EXISTS, multiplied its cost almost 200 times!
"Exists" is painfully slow.
The shared_buffers was reduced again.
Do you have any suggestions?
Many thanks.
Andre Felipe Machado
| Attachment | Content-Type | Size |
|---|---|---|
| sql_query_rewrite.txt.tar.gz | application/x-gzip | 11.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-03-14 19:36:25 | Re: firebird X postgresql 8.1.2 windows, performance comparison |
| Previous Message | mcelroy, tim | 2006-03-14 17:28:17 | Re: Vacuum template databases, Urgent: Production probl |