Sorry, I got a bit lost in the thread. BTW, Thanks for all the answers :)
On Wed, Oct 28, 2009 at 12:29 AM, Alvaro Herrera wrote:
> JC Praud escribió:
>
> > - Last night the database locked. pg_log full of messages about insert
> into
> > the mother table waiting for a lo
On Tue, Oct 27, 2009 at 6:31 PM, Alvaro Herrera
wrote:
> JC Praud escribió:
>
> > So my question are: can the autovacuum daemon perform vacuum full ? Or
> > another internal postgres process ? Could it come from the TRUNCATE I run
> > and canceled 4 days before ?
>
&g
Hi all,
I've got a weird thing on one of my databases this night:
- I've a monthly partition for storing activity logs defined as this:
- mother log table
- one child partition for each month
- Last friday I dumped the last month partition, and tried to truncate it,
which locked lots of quer
Hi all,
I'm trying to monitor databases with munin. For security reasons I guess it
is better to create a specialized user "munin" or like that and grant it
only the necessary rights: no superuser rights, nor write access on my
applications databases.
My problem is, this user cannot access to inf
