postgres does not respond to a query view of 10000 records roughl y - Mailing list pgsql-general

From Claudia D'amato
Subject postgres does not respond to a query view of 10000 records roughl y
Date
Msg-id 7965BF282720D8118ED70050BA4E75760A9517@ml370.omarnet.it
Whole thread Raw
Responses Re: postgres does not respond to a query view of 10000
List pgsql-general

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

pgsql-general by date:

Previous
From: "Jeff Cave"
Date:
Subject: Re: Any commercial shopping cart packages using postgresql?
Next
From: Troels Arvin
Date:
Subject: Re: LIMIT modifier