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

Problem with 7.4.1 and complicated queries

P: n/a
Cheers,

I have a problem with postgresql7.4.1 on a SuSE machine. I use the
database for a C#-application for a small company to store their
clients, sales, etc... This all works flawless since 1 year. Since 2
weeks the database hangs if I perform long queries with views involved
in order to generate long reports about sales per month per categorie
and so on. The database does not respond and only I dump the database
and work on the dump I can continue. Working on the old set does not
work.

Each night, I run vacuumdb, but it does not help.

Is this something known?

I can send you more information if needed.

Thanks,
Jonathan

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.