By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,712 Members | 1,958 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,712 IT Pros & Developers. It's quick & easy.

Postgres respond after toomany times to a query view

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 16 Dec 2003, claudia wrote:
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


We'll need to see a couple things:

schema of the underlying tables, your view definition, and the output of:
"explain analyze select * from view;"

Also, what version of postgresql are you running?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

P: n/a
It would be good if u can give text of the view and table structure of
the two tables.

Some of the things u can do is.

VACCUM and ANALYZE tables;
Create index on coulmn specified in where clause of the query.

Manoj
claudia wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.