| From: | "Doron Baranes" <doron(dot)baranes(at)dbnet(dot)co(dot)il> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: |
| Date: | 2006-04-10 08:30:37 |
| Message-ID: | 0BA77301DFF4B24C9C5DAA74138BF95001E202@exchange-1.dbnet.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I Attached here a file with details about the tables, the queries and
the
Explain analyze plans.
Hope this can be helpful to analyze my problem
10x
Doron
-----Original Message-----
From: Ragnar [mailto:gnari(at)hive(dot)is]
Sent: Sunday, April 09, 2006 2:37 PM
To: Doron Baranes
Subject: RE: [PERFORM]
On sun, 2006-04-09 at 14:11 +0200, Doron Baranes wrote:
Please reply to the list, not to me directly. this way
others can help you too.
> I did vacuum database analyze a few days ago.
yes, I saw that in your original post. I mentioned
VACUUM FULL ANALYZE , not just VACUUM ANALYZE
> I'll attached a few explain plans.
[explain plans deleted]
These are useless. you must show us the output of
EXPLAIN ANALYZE. these are output of EXPLAIN.
A plan is not much use without seeing the query itself.
you still have not answered the question about
what indexes you have.
gnari
| Attachment | Content-Type | Size |
|---|---|---|
| explain_analyze.txt | text/plain | 10.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2006-04-10 08:43:31 | Re: Restore performance? |
| Previous Message | Jesper Krogh | 2006-04-10 08:22:31 | Dump restore performance 7.3 -> 8.1 |