Re: pgadmin trys to get the whole table?

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: Antoine <melser(dot)anton(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgadmin trys to get the whole table?
Date: 2006-03-07 20:53:17
Message-ID: C033A33D.75BB%dpage@vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 7/3/06 20:38, "Antoine" <melser(dot)anton(at)gmail(dot)com> wrote:

> Hi,
> It seems like pgadmin is trying to get the entire contents of a table
> when opening a table browser - is this right? We have a table with
> well over a million rows and, well, this is not good!

Yes, this is exactly what will happen unless you use the 'View Filtered
Data' option and specify a restriction (WHERE) clause.

SVN trunk (that will become 1.6 eventually) also contains a 'View Top N'
option, where N can be easily changed as required.

Regards, Dave.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Alexander Kirpa 2006-03-09 03:13:25 pgadmin III v1.4.2 Crash on delete
Previous Message Antoine 2006-03-07 20:38:39 pgadmin trys to get the whole table?