Re: Poor Performance on Postgres 8.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Poor Performance on Postgres 8.0
Дата
Msg-id 25930.1106945442@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
Ответы Re: Poor Performance on Postgres 8.0  (Pallav Kalva <pkalva@deg.cc>)
Список pgsql-performance
I was able to duplicate this behavior with dummy data that had only a
few distinct values for fknamestringid --- the planner then thinks that
the index probe into attribute will match a lot of rows and hence take a
long time.  Could we see your pg_stats row for fknamestringid, ie

select * from pg_stats
where tablename = 'attribute' and attname = 'fknamestringid';

It would be interesting to see the same for your 7.4 installation too.

            regards, tom lane

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

Предыдущее
От: Kevin Brown
Дата:
Сообщение: Re: PostgreSQL clustering VS MySQL clustering
Следующее
От: Pallav Kalva
Дата:
Сообщение: Re: Poor Performance on Postgres 8.0