Re: Different execution plan between PostgreSQL 8.2 and 12.5

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Different execution plan between PostgreSQL 8.2 and 12.5
Дата
Msg-id ac341640-345f-2848-bcd9-ac814787ff02@aklaver.com
обсуждение исходный текст
Ответ на Different execution plan between PostgreSQL 8.2 and 12.5  (gzh <gzhcoder@126.com>)
Ответы Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5  (gzh <gzhcoder@126.com>)
Список pgsql-general
Дерево обсуждения 
On 8/17/22 20:01, gzh wrote:
> Hi,
> 
> 
> I have had a Perl Website working for 7 years and have had no problems
> 
> until a few weeks ago I replaced my database server with a newer one.

Did you run ANALYZE on the 12.5 server after restoring the data to it?


> 
> gzh
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Different execution plan between PostgreSQL 8.2 and 12.5
Следующее
От: Ron
Дата:
Сообщение: Re: Setting up streaming replication on large database (20+ TB) for the first time