Thread: postgres does not respond to a query view of 10000 records roughl y

postgres does not respond to a query view of 10000 records roughl y

From
Claudia D'amato
Date:

Hi, I developing a program usinn postgres and linux like system operation. My problem is this:
I have a view quite complicated with roughly 10000 record. When I execute a simple query like this
        "select * from myview"
postgres does not respond and does not produce any results. I hope that someone can help me with some suggestion about reason of this behavior and some solution to avoid it. Thank you for your attentions and I hope to receive some feedback as soon as possible

Re: postgres does not respond to a query view of 10000

From
Jonathan Bartlett
Date:
You need to include more information.  Like the table structure and the
view.  In addition, you should probably post the "explain" output.

Jon

On Mon, 15 Dec 2003, Claudia D'amato wrote:

> Hi, I developing a program usinn postgres and linux like system operation.
> My problem is this:
> I have a view quite complicated with roughly 10000 record. When I execute a
> simple query like this
>     "select * from myview"
> postgres does not respond and does not produce any results. I hope that
> someone can help me with some suggestion about reason of this behavior and
> some solution to avoid it. Thank you for your attentions and I hope to
> receive some feedback as soon as possible
>