[ADMIN] Statistics Collector & Query Optimizer, any relation?

Hi, list, Does statistics has any relation to query optimizer? If I turn on statistics collector, will it do help to query optimizer? Regards Simon Chen. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] nscd [was] how do you run postgres without dns server

Do you got "hosts: files dns" in your nsswitch.conf? Otherwise , /etc/hosts won't be used. - # /etc/nsswitch.conf # # Example configuration of GNU Name Service Switch functionality. # If you have the `glibc-doc' and `info' packages i

[ADMIN] When will my database crash?

We have a postgres 7.4 database which never vacuum for 4 months. I try to vacuum one time. But my manager can't bear the low performance of website. So I had to kill the vacuum before it finished. Is it ok for a postgres 7.4 database never do vacuuming? We have 10,000 trans every day. That wo