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-hackers(at)postgresql(dot)org
Subject: postgres does not respond to a query view of 10000 records roughl y
Date: 2003-12-15 16:59:28
Message-ID: 7965BF282720D8118ED70050BA4E75760A9522@ml370.omarnet.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-12-15 18:23:14 Re: [HACKERS] [PATCHES] fork/exec patch
Previous Message Tom Lane 2003-12-15 14:53:23 Re: ORDER BY and DISTINCT ON