Re: performance with query

Поиск
Список
Период
Сортировка
От Alberto Dalmaso
Тема Re: performance with query
Дата
Msg-id 1245222474.5027.93.camel@dalmaso-opensuse.cl
обсуждение исходный текст
Ответ на performance with query  (Alberto Dalmaso <dalmaso@clesius.it>)
Ответы Re: performance with query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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.

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alan Li
Дата:
Сообщение: 8.4 COPY performance regression on Solaris
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: performance with query (OT)