Thread: postgres does not respond to a query view of 10000 records roughl y
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
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 >