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

From: Claudia D'amato <claudia(dot)damato(at)allaxia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres does not respond to a query view of 10000 records roughl y
Date: 2003-12-15 16:43:51
Message-ID: 7965BF282720D8118ED70050BA4E75760A9517@ml370.omarnet.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Moe 2003-12-15 16:53:15 Re: Any commercial shopping cart packages using postgresql?
Previous Message scott.marlowe 2003-12-15 16:25:41 Re: [GENERAL] Reordering results for a report