t;. Also how often the tables in the views are update and
how often you vacuum analyze will have a big impact on performance.
- Original Message -
From:
Claudia D'amato
To: [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 3:15
AM
Subject: [HACKERS] Postgres
Title: Postgres respond after toomany times to a query view
Hi, I developing a program using postgres and linux like operating system. My problem is this:
I have a quite complicated view with roughly 1 record. When I execute a simple query like this
"select * from myview"
postgres
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
On Tuesday 16 December 2003 10:32, Claudia D'amato wrote:
> I have a quite complicated view with roughly 1 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 ab
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 1 record. When I
execute a simple query like this
"select * from myview"
postgres respond after 50 - 55 minutes roughly. I hope that someone
c
a definition for the
tables involved.
-Original Message-From: Claudia D'amato
[mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16,
2003 2:32 AMTo: [EMAIL PROTECTED]Subject:
[HACKERS] Postgres respond after toomany times to a query
view
Hi, I am developing a prog
Title: Postgres respond after toomany times to a query view
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 1 record. When I execute a simple query like this
"select * from myview"
post
Title: Postgres respond after toomany times to a query view
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 1 record. When I execute a simple query like this
"select * from myview"
po
