pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Keith <keith@keithf4.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Read performance on Large Table
Date: Thu, 21 May 2015 10:34:49 -0600
Message-ID: <C591EA33-4121-454A-9ECA-A90518A5B7E2@elevated-dev.com> (raw)
In-Reply-To: <CAHw75vvOYDPcocBXbsik76SWVGMCqSnn+_=p7=dSw8NyChEM8g@mail.gmail.com>
References: <CA+ebzukaZJVOjw2Vqg0cuCUqbaEEHHuCa-pNbsX6CWAZyga3Fw@mail.gmail.com>
	<CAOR=d=3Ft9x+r0N30a_ASgLtSDFNA_m-H7_-sdFuOqD3FRyjPg@mail.gmail.com>
	<580E17C5-363E-4D24-B381-80A1F4C83C81@elevated-dev.com>
	<CAOR=d=08=D-nui40rhsk7dM36L8L99ocvHXJ75Agyvd-_hazpQ@mail.gmail.com>
	<1295589F-361A-4C3E-BA25-3A4F34C3CAB2@elevated-dev.com>
	<CAHw75vvNw_-3GLF3N5g6qmSAgC8WLzEr_u8yeDQ_uUq7Xt4MhQ@mail.gmail.com>
	<DA2568CB-CFAE-4530-9486-88AA4E3D9179@elevated-dev.com>
	<CAHw75vvOYDPcocBXbsik76SWVGMCqSnn+_=p7=dSw8NyChEM8g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

On May 21, 2015, at 10:25 AM, Keith <keith@keithf4.com> wrote:
> 
> The problem with creating partitions on the fly via triggers, even ahead of when they're needed, is you run into BIG contention issues when you have high insert rates. One session will see it needs to create a new table, the next one comes in before the table is made but either gets put into a wait state or outright fails when it goes to try and make the new table that's already there…

No failure, I handle the exception.

> It may not be an issue for you, but it's definitely something to keep in mind if you notice performance issues. :) 
> 

Right. Around midnight this db has very low activity.

-- 
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (12+ messages)

Message-ID: <C591EA33-4121-454A-9ECA-A90518A5B7E2@elevated-dev.com>
Permalink:  ../C591EA33-4121-454A-9ECA-A90518A5B7E2@elevated-dev.com/
Also on:    postgresql.org/message-id/C591EA33-4121-454A-9ECA-A90518A5B7E2@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, keith@keithf4.com, scott.marlowe@gmail.com
  Subject: Re: Read performance on Large Table
  In-Reply-To: <C591EA33-4121-454A-9ECA-A90518A5B7E2@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox