Hi also,
On Sat, Mar 08, 2014 at 20:08:03 +0100, Christoph Berg wrote:
[...]
> > > /tmp is possibly still better than the data directory.
> >
> > Yes, indeed. Especially on machines with a reasonable amount of
> > memory it is advisable to put /tmp/ on a tmpfs, and I guess many
> > people do tha
Hey,
On Sat, Mar 08, 2014 at 17:53:07 +0100, Martin Pitt wrote:
[...]
> > Note that pg_ctlcluster creates the stats_temp_directory
> > and sets the owner of that directory to the cluster owner.
> > So for clusters that root/postgres created but hands over
> > to other people, this should actually
Re: Christian Tacke 2014-03-08 <20140308115643.ga20...@ahorn.local.lan>
> > /var/run/lock wouldn't work because it's too small (5120k here).
>
> stats_temp_directory files are often quite small. My small
> cluster has a 58 kB pgstat.stat. So this could work.
It'll easily grow to a handfull of meg
Hey all,
Christian Tacke [2014-03-08 12:56 +0100]:
> > > Note that this is a little too simplistic. This directory is only
> > > writable to clusters owned by postgres. While that is the default, you
> > > can assign any other owner, and you can even call pg_createcluster as
> > > a normal user an
Hi,
(excuse my previous empty mail, hit the wrong button)
On Fri, Mar 07, 2014 at 13:40:53 +0100, Christoph Berg wrote:
> Re: Martin Pitt 2014-03-07 <20140307090805.ga23...@piware.de>
[...]
> > > +
> > > +# Starting at version 8.4 one can move the pg_stat_tmp dir
> > > +stats_temp_directory = '
On Fri, Mar 07, 2014 at 13:40:53 +0100, Christoph Berg wrote:
> Re: Martin Pitt 2014-03-07 <20140307090805.ga23...@piware.de>
> > I think configuring a tmpfs dir by default is a good idea, thanks for
> > pointing that out.
>
> +1.
>
> > > === modified file 'createcluster.conf'
> > > --- createcl
Re: Martin Pitt 2014-03-07 <20140307132111.gd2...@piware.de>
> Christoph Berg [2014-03-07 13:40 +0100]:
> > pg_createcluster will still want to write to /etc/postgresql which is
> > owned by postgres, so the stats_temp_directory doesn't make the
> > situation worse.
>
> That's different, though. I
Christoph Berg [2014-03-07 13:40 +0100]:
> pg_createcluster will still want to write to /etc/postgresql which is
> owned by postgres, so the stats_temp_directory doesn't make the
> situation worse.
That's different, though. If you use /etc/postgresql/ then
pg_createcluster of course still needs to
Re: Martin Pitt 2014-03-07 <20140307090805.ga23...@piware.de>
> I think configuring a tmpfs dir by default is a good idea, thanks for
> pointing that out.
+1.
> > === modified file 'createcluster.conf'
> > --- createcluster.conf 2013-04-12 12:32:08 +
> > +++ createcluster.conf 2014-
Hello Christian,
Christian Tacke [2014-02-17 13:14 +0100]:
> PGDATA/pg_stat_tmp/* is written to a lot, even on a
> completely idle system. This is not good if running on an
> SSD or alike. That's for my motivation.
>
> This directory is only needed at runtime, so putting it in
> /var/run seems mo
10 matches
Mail list logo