Re: Perplexing, regular decline in performance

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Perplexing, regular decline in performance
Дата
Msg-id CAH2-Wz=n3wMRF7ZEonS5yQWw5drwyTbbPp82iZUrv_FaWqRBbw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Perplexing, regular decline in performance  (Hugh Ranalli <hugh@whtc.ca>)
Список pgsql-performance
On Wed, Jun 26, 2019 at 12:02 PM Hugh Ranalli <hugh@whtc.ca> wrote:
> I'm sorry, but I'm not sure what you mean by the "distribution of values within the columns." Can you clarify or
providean link to an example?
 

I would mostly just like to see the schema of the table in question,
including indexes, and a high-level description of the nature of the
data in the table. Ideally, you would also include pg_stats.*
information for all columns in the table. That will actually let us
see a summary of the data. Though you should be careful about leaking
sensitive information that happens to be contained in the statistics,
such as the most common values.

-- 
Peter Geoghegan



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

Предыдущее
От: Hugh Ranalli
Дата:
Сообщение: Re: Perplexing, regular decline in performance
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Perplexing, regular decline in performance