Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-12 Thread Mathieu Fenniak
.de> wrote: > Hi Tom, Mathieu, > > On 2017-05-10 17:02:11 -0400, Tom Lane wrote: > > Mathieu Fenniak <mathieu.fenn...@replicon.com> writes: > > > Andres, it seems like the problem is independent of having large data > > > manipulations mixed with schema

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-10 Thread Mathieu Fenniak
er_timeout = 3600s; max_locks_per_transaction = 65536; max_replication_slots = 5) On Fri, May 5, 2017 at 7:38 PM, Andres Freund <and...@anarazel.de> wrote: > On 2017-05-05 21:32:27 -0400, Tom Lane wrote: > > Andres Freund <and...@anarazel.de> writes: > > > On 2017-05-

[GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-05 Thread Mathieu Fenniak
e, and have a discussion with me about what kind of changes might be necessary to improve the performance. Thanks all, *Mathieu Fenniak* | Senior Software Architect | Phone 1-587-315-1185 *Replicon* | The leader in cloud time tracking applications - 7,800+ Customers - 70+ Countries - 1.5 Millio

[GENERAL] fast-archiver tool, useful for pgsql DB backups

2012-08-24 Thread Mathieu Fenniak
Hi pgsql-general, Has anyone else ever noticed how slow it can be to rsync or tar a pgdata directory with hundreds of thousands or millions of files? I thought this could be done faster with a bit of concurrency, so I wrote a little tool called fast-archiver to do so. My employer (Replicon) has