Re: Postgres respond after toomany times to a query view

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

In response to

Browse pgsql-hackers by date

  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