Re: pg_restore takes more time on creation of rules

2019-05-22 Thread Tomas Vondra
On Wed, May 22, 2019 at 06:44:29PM +0300, Mariel Cherkassky wrote: By rules I mean DB rules (simillar to triggers but different) I very much doubt such high number of rules was expected during the design (especially if it's on a single table), so perhaps there's an O(N^2) piece of code somewhe

Re: pg_restore takes more time on creation of rules

2019-05-22 Thread Mariel Cherkassky
By rules I mean DB rules (simillar to triggers but different) ‫בתאריך יום ד׳, 22 במאי 2019 ב-18:41 מאת ‪Tomas Vondra‬‏ <‪ tomas.von...@2ndquadrant.com‬‏>:‬ > On Wed, May 22, 2019 at 06:26:49PM +0300, Mariel Cherkassky wrote: > >Hey, > >I'm trying to restore a cluster (9.2) from 3 binary dumps (pg

Re: pg_restore takes more time on creation of rules

2019-05-22 Thread Tomas Vondra
On Wed, May 22, 2019 at 06:26:49PM +0300, Mariel Cherkassky wrote: Hey, I'm trying to restore a cluster (9.2) from 3 binary dumps (pg_dump -Fc). Each dump contains only one database. The sizes : A-10GB B-20GB C-5GB. For unclear reason the restore of the third database is taking alot of time. It