| From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
|---|---|
| To: | "Claudia D'amato" <claudia(dot)damato(at)allaxia(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgres does not respond to a query view of 10000 |
| Date: | 2003-12-19 22:06:55 |
| Message-ID: | Pine.GSU.4.44.0312191406210.2775-100000@eskimo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-20 00:37:26 | Re: PostgreSQL speakers needed for OSCON 2004 |
| Previous Message | Jonathan Bartlett | 2003-12-19 22:05:57 | Re: Salvage older PostgreSQL data disk - help? |