On Tue, Apr 5, 2016 at 1:37 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 04/05/2016 10:10 AM, Melvin Davidson wrote: > >> >> >> > >> FYI, in PgAdmin, there is an Option which determines if a _physical row >> count_ should be performed if the _estimated_ row count is less than a >> specified amount. It defaults to 2000. >> To change it, Click on File, Options and under Browser click Properties. >> There you can change the default. >> > > So that means it does select count(*) from the_table every time you click > on the table properties if the estimated count is less then the set amount? > > > -- >> *Melvin Davidson* >> I reserve the right to fantasize. Whether or not you >> wish to share my fantasy is entirely up to you. >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > >So that means it does select count(*) from the_table every time you click on the table properties if the estimated count is less then the set amount? I believe so. That is why the default is low (2k). If you set it higher, it will naturally take longer. I did not write or contribute to PgAdmin, so there is no point in complaining about it. It's just a user option. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
