Postgres respond after toomany times to a query view

From: Claudia D'amato <claudia(dot)damato(at)allaxia(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postgres respond after toomany times to a query view
Date: 2003-12-16 10:16:38
Message-ID: 7965BF282720D8118ED70050BA4E75760A959E@ml370.omarnet.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Claudia D'amato 2003-12-16 10:32:14 Postgres respond after toomany times to a query view
Previous Message Magnus Hagander 2003-12-16 10:09:03 Re: [HACKERS] [PATCHES] fork/exec patch