Re: Multi-second pauses blocking even trivial activity

Andreas -- just following up to say that this was indeed the root cause. Thanks again. Patrick On Sat, 8 Sep 2018, 01:34 Patrick Molgaard, wrote: > This sounds extremely plausible -- thanks for the tip, Andreas. > > Best, > Patrick > > > On Fri, 7 Sep 2018, 19:20 Andreas Kretschmer, > wrote: >

Re: Why could different data in a table be processed with different performance?

On 09/21/2018 08:28 AM, Vladimir Ryabtsev wrote: >> but you say you observe a difference even after dropping the cache. > No, I say I see NO significant difference (accurate to measurement > error) between "with caches" and after dropping caches. And this is > explainable, I think. Since I read

Re: Why could different data in a table be processed with different performance?

Hi Vladimir, On 09/21/2018 02:07 AM, Vladimir Ryabtsev wrote: > > I have such a table: > > CREATE TABLE articles > ( >     article_id bigint NOT NULL, >     content jsonb NOT NULL, >     published_at timestamp without time zone NOT NULL, >     appended_at timestamp without time zone NOT NULL,