From: | Alberto Dalmaso <dalmaso(at)clesius(dot)it> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: performance with query |
Date: | 2009-06-17 07:07:54 |
Message-ID: | 1245222474.5027.93.camel@dalmaso-opensuse.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Ok, here are the last rows for the vacuum analyze verbose
INFO: free space map contains 154679 pages in 39 relations
DETAIL: A total of 126176 page slots are in use (including overhead).
126176 page slots are required to track all free space.
Current limits are: 160000 page slots, 5000 relations, using 1476 kB.
L'interrogazione è stata eseguita con successo, ma senza risultato, in
1332269 ms.
and I attach the complete explain analyze of the complex query.
Giving more detail about the tables involved in the query could be not
so easy as they are a lot.
The joins are made between columns that are primary key in a table and
indexed in the other.
All the where clausole are on indexed colums (perhaps there are too many
indexes...)
Thanks a lot.
Attachment | Content-Type | Size |
---|---|---|
long_query_analyze.txt | text/plain | 15.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2009-06-17 07:16:59 | Re: performance with query (OT) |
Previous Message | Alan Li | 2009-06-17 05:46:12 | 8.4 COPY performance regression on Solaris |