| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Dann Corbit <DCorbit(at)connx(dot)com> |
| Cc: | "Claudia D'amato" <claudia(dot)damato(at)allaxia(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Postgres respond after toomany times to a query view |
| Date: | 2003-12-16 11:01:30 |
| Message-ID: | 1071572490.5082.6.camel@fuji.krosing.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dann Corbit kirjutas T, 16.12.2003 kell 12:40:
> I suspect if you do "explain" against the SQL of the view, the answer
> will be apparent.
>
> Donning my "Karnak the magnificent hat {borrowed from Johnny Carson}":
> You are missing an index.
>
> For the best help, post the SQL of your view, and also the Schema
> definition for the tables involved.
Also, the best place for asking about performance is the
pgsql-performance list :)
------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-12-16 11:01:37 | Re: Postgres respond after toomany times to a query view |
| Previous Message | claudia | 2003-12-16 10:50:21 | Postgres respond after toomany times to a query view |