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
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 outp
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 kn
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:
According to these lines you should set max_fsm_pages to at the very
least 5306160
You have a humongous amount of RAM, you could set it to 1000
INFO: free space map: 79 relations, 1948399 pages stored; 5306160 total
pages needed
DETAIL: Allocated FSM size: 500 relations + 200 page
