The pgAdmin performance on one of our database servers has been dismal
for a while now. I captured one of the queries that was taking forever
to return, therefore making pgAdmin unresponsive for up to 10 minutes.
The query is as follows:
SELECT rel.oid, relname, rel.reltablespace AS spcoid, spcnam
On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
> I looked at the pg_class table and noticed that its size is 1010Mb and
> index size is 1137Mb, while the table itself has only 3615 rows in it.
> I tried vacuuming it, but that did not change anything. Is there
> anything I can do to get this tabl
On May 5, 3:37 pm, j...@commandprompt.com ("Joshua D. Drake") wrote:
> On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
> > I looked at the pg_class table and noticed that its size is 1010Mb and
> > index size is 1137Mb, while the table itself has only 3615 rows in it.
> > I tried vacuuming it, but
Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010:
> On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
>
> > I looked at the pg_class table and noticed that its size is 1010Mb and
> > index size is 1137Mb, while the table itself has only 3615 rows in it.
> > I tried vacuumin
On May 5, 6:16 pm, alvhe...@alvh.no-ip.org (Alvaro Herrera) wrote:
> Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010:
>
> > On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
>
> > > I looked at the pg_class table and noticed that its size is 1010Mb and
> > > index size is 1