Postgres respond after toomany times to a query view

Started by Claudia D'amatoabout 22 years ago1 messages
#1Claudia D'amato
claudia.damato@allaxia.com
Show quoted text

Hi, I am developing a program using postgres and linux like operating
system. My problem is this:
I have a quite complicated view with roughly 10000 record. When I execute
a simple query like this
"select * from myview"
postgres respond after 50 - 55 minutes roughly. I hope that someone can
help me with some suggestion about reason of this behavior and some
solution to reduce time ti have results. Thank you for your attentions and
I hope to receive some feedback as soon as possible