> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: 23 October 2003 11:51
> To: Dave Page
> Cc: Constantin Stefanov; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
&g
Dave Page wrote:
-Original Message-
From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
Sent: 23 October 2003 08:59
To: [EMAIL PROTECTED]
Subject: Re: [pgadmin-support] Very slow viewing of large table.
SELECT relname, reltuples FROM pg_class;
For my table there is
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 23 October 2003 08:59
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
>
> > SELECT relname, reltuples FROM pg_class;
Dave Page wrote:
Thanks, I set that value to 0, and now I have the desired behaviour.
But, for that table the values are:
Rows(estimated) - 7
Rows(counted) - 77204608
I think the difference is too large. From the debug output I
could not understand the query which pg_admin issues to have
the val
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 23 October 2003 07:30
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
>
> Thanks, I set that value to 0, and now I have the desired behav
Dave Page wrote:
-Original Message-
From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
Sent: 22 October 2003 14:53
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] Very slow viewing of large table.
When in PgAdmin3 I click on a large table, it waits before
opening it.
As far as I
> -Original Message-
> From: Constantin Stefanov [mailto:[EMAIL PROTECTED]
> Sent: 22 October 2003 14:53
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Very slow viewing of large table.
>
> Hello.
>
> When in PgAdmin3 I click on a large table, it
Hello.
When in PgAdmin3 I click on a large table, it waits before opening it.
As far as I could understand, it issues a row count on a table. Is there
way to stop this behaviour?
I found a letter about the same problem of February 2002, and Dave Page
wrote he was intending to do something about