Re: PgAdmin startup query VERY slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Michael Shapiro <mshapiro(at)ncsa(dot)edu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PgAdmin startup query VERY slow
Date: 2004-01-06 23:12:35
Message-ID: 1687.1073430755@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Incidentally, just ANALYZE would probably have fixed your problem.

... or just VACUUM; that would have updated the row count which is all
that was really needed here. The main point is that you do have to do
that as superuser, since the same commands issued as a non-superuser
won't touch the system tables (or any table you do not own).

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-01-06 23:19:55 Re: Select max(foo) and select count(*) optimization
Previous Message D'Arcy J.M. Cain 2004-01-06 22:57:05 Re: Select max(foo) and select count(*) optimization