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 gener
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 genera
Hi!
>
> This sounds like maybe you're FSM settings aren't high enough, or you
> aren't analyzing your tables.
I doubled the values for max_fsm_pages and max_fsm_relations.
> Try vacuum full and analyze first, and see if that fixes the problem.
> If so, then you either need to vacuum more often,
so it is not the gui or a network
timeout. This query worked for over one year, nobody changed
something.
VACUUM FULL ; ANALYZE;
will not change anything.
Any hints?
Thank you,
Jonathan
On Sun, 24 Oct 2004 22:00:09 +0200, Jonathan Weiss <[EMAIL PROTECTED]> wrote:
> Hi!
>
> >
