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

From: Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
To: pryzby(at)telsasoft(dot)com
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Why could different data in a table be processed with different performance?
Date: 2018-09-25 03:40:28
Message-ID: CAMqTPqkRAxhAth9Au_=w=mshUPy3wb27sptEzAJuddkL9fH9cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> but I'd be curious to know
> SELECT schemaname, tablename, attname, correlation FROM pg_stats WHERE
tablename='articles' AND column='article_id' LIMIT 1;
I think you meant 'attname'. It gives
storage articles article_id -0.77380306

Vlad

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gasper Zejn 2018-09-25 06:32:09 Re: Why could different data in a table be processed with different performance?
Previous Message Justin Pryzby 2018-09-25 02:38:52 Re: Why could different data in a table be processed with different performance?