Re: [PERFORM] poor performance in migrated database

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [PERFORM] poor performance in migrated database
Дата
Msg-id 1099777150.6942.393.camel@localhost.localdomain
обсуждение исходный текст
Ответ на poor performance in migrated database  (Carlos Lopez <chlopezl@yahoo.com>)
Ответы Re: [PERFORM] poor performance in migrated database  (Carlos Lopez <chlopezl@yahoo.com>)
Список pgsql-admin
On Sat, 2004-11-06 at 19:52, Carlos Lopez wrote:
> The problem is that there are many nested views which
> normally join tables by using two fields, one
> character and other integer.

PostgreSQL has difficulty with some multi-column situations, even though
in general it has a particularly good query optimizer.

If the first column is poorly selective, yet the addition of the second
column makes the combination very highly selective then PostgreSQL may
not be able to realise this, ANALYZE or not. ANALYZE doesn't have
anywhere to store multi-column selectivity statistics.

EXPLAIN ANALYZE will show you whether this is the case. It seems likely
that the estimated cardinality of certain joins is incorrect.

--
Best Regards, Simon Riggs


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

Предыдущее
От: Troels Arvin
Дата:
Сообщение: Re: poor performance in migrated database
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: [PERFORM] poor performance in migrated database