ppen every 5 minutes and takes about
4.5 mins which corresponds to the 0.9 checkpoint_completion_target we have set.
> On 28 Oct 2015, at 19:20, Jeff Janes wrote:
>
> On Wed, Oct 28, 2015 at 8:43 AM, Tom Dearman wrote:
>> We have a performance problem when our postgres is under high
@postgresql.org
> <mailto:pgsql-general-ow...@postgresql.org>
> [mailto:pgsql-general-ow...@postgresql.org
> <mailto:pgsql-general-ow...@postgresql.org>] On Behalf Of Tom Dearman
> Sent: Wednesday, October 28, 2015 11:44 AM
> To: pgsql-general@postgresql.org <mailto:pgsq
I am partitioning a number of tables in our system and am using a view on the
real master table with 'instead of’ triggers to insert and update rows. I have
used a view because my application uses Hibernate which does not work well with
triggers that return a null to indicate no further process
