From: | "Dave Page" <dpage(at)postgresql(dot)org> |
---|---|
To: | "Bob Henkel" <bob(dot)henkel(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Minor Bug with large grid result |
Date: | 2007-07-24 17:54:24 |
Message-ID: | 200707241854250000@262037585 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> ------- Original Message -------
> From: "Bob Henkel" <bob(dot)henkel(at)gmail(dot)com>
> To: pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Vishal Arora | 2007-07-25 04:07:21 | Re: Error installing PostgreSQL core, 8.2 (password short, not complex) |
Previous Message | Bob Henkel | 2007-07-24 17:07:09 | Minor Bug with large grid result |