Hi, I 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





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 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
Tue, 16 Dec 2003 10:15:18 +0100
Claudia D'amato <claudia.damato@allaxia.com>
Postgres respond after toomany times to a query view
Postgres respond after toomany times to a query viewIt would help us to help you if you posted the view, tables involved and indexes on those table.  Also things like some of the postgresql.conf parameters would help.  Things like "effective_cache_size",  "sort_mem".   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: pgsql-hackers@postgresql.org 
  Sent: Tuesday, December 16, 2003 3:15 AM
  Subject: [HACKERS] 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 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

Postgres respond after toomany times to a query view





It would help us to help you if you posted the view, tables involved 
and indexes on those table.  Also things like some of the postgresql.conf 
parameters would help.  Things like "effective_cache_size",  
"sort_mem".   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: pgsql-hackers@postgresql.org

Sent: Tuesday, December 16, 2003 3:15 
  AM
Subject: [HACKERS] 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 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
Mon, 22 Dec 2003 10:54:30 -0600
"Glenn Wiorek" <gwiorek@jmlafferty.com>
Re: Postgres respond after toomany times to a query view