On Thu, May 25, 2006 at 06:04:33PM +0100, Greig A Cowan wrote:
> > We don't run gridftp doors on our pools - the gridftp doors run on
> > completely seperate systems. Yes, pnfs is on its own server.
> >
> > Have you vacuumed your database recently?
> >
> > http://www.postgresql.org/docs/8.1/interactive/maintenance.html#ROUTINE-VACUUMING
>
> Hi Derek,
>
> In this article in the wiki:
>
> https://www.gridpp.ac.uk/wiki/PostgreSQL_administration
>
> I think it should be
>
> stats_start_collector = on
Thats the one. Keep in mind that you get a ~5% overhead with the
stats collector on.
http://www.powerpostgresql.com/Docs/ is a good starting point for
good tuning tips if you want to further tune your server btw.
Cheers,
Kostas
|