Hello Eelco, Wednesday, October 9, 2002, 6:56:04 AM, you wrote:
EvBIS> Since there are a lot of postgresql experts on this list i want to EvBIS> share a problem we have on this moment. We have a large DBMAIL EvBIS> installation with a postgresql backend. It stores about 10 Gbyte of EvBIS> mailinformation but postgresql seems to be using 4 times as many EvBIS> diskspace. How is this possible and can it be reduced? The first few EvBIS> weeks this size difference wasn't so big. Try: VACUUM; or better yet: VACUUM ANALYSE; This is probably happening because you made a lot of I/O. The second form will collect statistics so that your queries should be optimized in the future. ------------- Best regards, Steve Howe mailto:[EMAIL PROTECTED]
