Re: performance with query

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

Responses

Browse pgsql-performance by date

  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