> ------- Original Message -------
> From: "Bob Henkel" <[EMAIL PROTECTED]>
> 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 size of dataset.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
