Re: [PERFORM] Config Check

Hasnul Fadhly bin Hasan wrote: Hi Bryan, Just wondering, i ran vacuumdb but didn't get the information that you get about the free space even when i set the verbose option. How did you get that? Thanks, Hasnul I believe it is VACUUM FULL ANALYZE VERBOSE; At the very end you will get a listing

[PERFORM] Config Check

Postgresql is the backbone of our spam filtering system. Currently the performance is OK. Wanted to know if someone could give this config a quick run down and see if there is anything we can adjust here to smooth out the performance. The IO Wait Times are outrageous, at times the load will

Re: [PERFORM] Config Check

Bryan [EMAIL PROTECTED] writes: vacuum_mem = 320 Yikes. You do realize that's measured in kilobytes? Try backing it off to something saner, like half a gig or less. regards, tom lane ---(end of broadcast)--- TIP 3:

Re: [PERFORM] Config Check

Hi Bryan, Just wondering, i ran vacuumdb but didn't get the information that you get about the free space even when i set the verbose option. How did you get that? Thanks, Hasnul Bryan wrote: Postgresql is the backbone of our spam filtering system. Currently the performance is OK. Wanted to

Re: [PERFORM] Config Check

Hasnul Fadhly bin Hasan [EMAIL PROTECTED] writes: Just wondering, i ran vacuumdb but didn't get the information that you get about the free space even when i set the verbose option. How did you get that? PG version? IIRC 7.4 was the first to include that info in the VACUUM VERBOSE output.