Thread: Minor Bug with large grid result

> ------- Original Message -------
> From: "Bob Henkel" <bob.henkel@gmail.com>
> To: pgadmin-support@postgresql.org
> Sent: 24/07/07, 18:07:09
> Subject: [pgadmin-support] Minor Bug with large grid result
> 
> Platform                   = Windows XP Pro
> Language                 = English
> Distribution you used = binary
> Version you tested    = 1.8.0 Beta 1 (Jul 13 2007, rev:6423)
> 
> When running the following statement SELECT RANDOM() FROM
> generate_series(1,9000000); the grid is populated with 9 million random
> values. When grabbing the scroll bar for the grid and moving(pulling) to the
> lower records with the mouse at around record 7 million the values in the
> grid start to get all garbled until the grid appears almost solid black.
> This doesn't appear to happen when using the page up or page down keys or
> the arrow keys or the mouse scroll wheel.  Obviously this isn't a high
> priority issue if this is all the problem relates to, but it's a problem
> none the less.
> 
> Also if you scroll down until the data in the grid gets garbles and tab to
> another app and back the grid window will have the contents of the app you
> tabbed from under the grid. Looks like some kind of refresh issue.

You have a use case for browsing 9M values? I don't think it's unreasonable to start running out of resources with that
sizeof dataset.
 

Regards, Dave