Re: Perplexing, regular decline in performance - Mailing list pgsql-performance

From Peter Geoghegan
Subject Re: Perplexing, regular decline in performance
Date
Msg-id CAH2-Wz=n3wMRF7ZEonS5yQWw5drwyTbbPp82iZUrv_FaWqRBbw@mail.gmail.com
Whole thread Raw
In response to Re: Perplexing, regular decline in performance  (Hugh Ranalli <hugh@whtc.ca>)
List 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 by date:

Previous
From: Hugh Ranalli
Date:
Subject: Re: Perplexing, regular decline in performance
Next
From: Alvaro Herrera
Date:
Subject: Re: Perplexing, regular decline in performance