Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -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

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Andreas Pflug
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

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -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;

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Constantin Stefanov
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

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -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

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-22 Thread Constantin Stefanov
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

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-22 Thread Dave Page
> -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

[pgadmin-support] Very slow viewing of large table.

2003-10-22 Thread Constantin Stefanov
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