Hello,
I'd like to ask you whether there is a way how to monitor and log details
about NOTIFY queue? What do you use for this prupose?
In the official documentation I'm unable to find a way how to monitor
NOTIFY queue in more detail, at least size of this queue, which is critical
in case of
I'm wrong (really!).
Thanks,
Jiri
On Thu, Nov 5, 2015 at 5:43 PM, Kevin Grittner <kgri...@ymail.com> wrote:
> On Thursday, November 5, 2015 12:16 AM, Jiří Hlinka <jiri.hli...@gmail.com>
> wrote:
>
> > My opinion is, that pg_repack should guarantee a consistent,
>
aquier <michael.paqu...@gmail.com>
wrote:
>
>
> On Wed, Nov 4, 2015 at 10:16 PM, Jiří Hlinka <jiri.hli...@gmail.com>
> wrote:
>
>> I'm on pg_repack 1.3.2 (latest sable, no devel version available to check
>> if it is already fixed).
>>
>> Michael: y
gt;
> Make sure you're on the latest version too. There were some recent commits
> aimed at fixing some race conditions.
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
> Experts in Analytics, Data Architecture and PostgreSQL
> Data in Trouble? Get it in Treble! http://BlueTreble.com
>
--
Bc. Jiří Hlinka
Tel.: 725 315 263
I'm running a pg_repack from a bash script with timeout of 10 minutes like
so (simplified version):
timeout -s SIGINT 10m pg_repack --table=frequently_updated_table
After the 10 min timeout, the OS sends SIGINT to pg_repack process so the
pg_repack calls:
SELECT repack.repack_drop($1, $2)
and it
Hi list,
I'd like to ask you if you have any experience with some solution or how do
you manage tasks described below.
We have tens of separate databases (for different apps and purpose) which
we want send regular tasks to. The tasks are always SQL queries, for
example count some bilance after
Hello,
I'd like to setup a testing environment which is based on a current
production server status. The DB server is pgsql 8.4 (subscribed RHEL, so
can't use hot standby or other 9.0+ options). The objective is to have a db
server that I could clone many times a day to auto-build many testing
