Postgres Pro
Downloads
Home   >   mailing lists

Re: Why could different data in a table be processed with different performance? - Mailing list pgsql-performance

From Vladimir Ryabtsev
Subject Re: Why could different data in a table be processed with different performance?
Date
Msg-id CAMqTPqkRAxhAth9Au_=w=mshUPy3wb27sptEzAJuddkL9fH9cw@mail.gmail.com
Whole thread Raw
In response to Re: Why could different data in a table be processed with differentperformance?  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view
> 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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Why could different data in a table be processed with differentperformance?
Next
From: Gasper Zejn
Date:
Subject: Re: Why could different data in a table be processed with differentperformance?