Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UsIIQ-00032I-9E for pgsql-performance@arkaria.postgresql.org; Thu, 27 Jun 2013 19:55:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UsIIP-0004IM-Ny for pgsql-performance@arkaria.postgresql.org; Thu, 27 Jun 2013 19:55:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UsIIO-0004H1-GO for pgsql-performance@postgresql.org; Thu, 27 Jun 2013 19:55:56 +0000 Received: from smtp2.peak6.com ([38.98.137.9]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UsIII-0006WP-Kv for pgsql-performance@postgresql.org; Thu, 27 Jun 2013 19:55:56 +0000 X-AuditID: 0a02cb20-b7f216d000002f75-4b-51cc98c17f1a Received: from sswchi5pcas2.peak6.net (Unknown_Domain [10.100.13.24]) by smtp2.peak6.com (Symantec Messaging Gateway) with SMTP id 1D.E8.12149.1C89CC15; Thu, 27 Jun 2013 14:55:45 -0500 (CDT) Received: from [10.10.201.64] (10.10.201.64) by sswchi5pcas2.peak6.net (10.100.13.25) with Microsoft SMTP Server (TLS) id 14.3.123.3; Thu, 27 Jun 2013 14:55:44 -0500 Message-ID: <51CC98C0.7020308@optionshouse.com> Date: Thu, 27 Jun 2013 14:55:44 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130510 Thunderbird/17.0.6 MIME-Version: 1.0 To: Andrew Dunstan CC: Tom Lane , Dave Johansen , bricklen , "pgsql-performance@postgresql.org" Subject: Re: Partitions not Working as Expected References: <51CC652F.3010304@optionshouse.com> <51CC73B6.2050406@optionshouse.com> <51CC8160.2080905@optionshouse.com> <27533.1372358546@sss.pgh.pa.us> <51CC8F1A.1090805@optionshouse.com> <51CC9746.5060804@dunslane.net> In-Reply-To: <51CC9746.5060804@dunslane.net> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrJKsWRmVeSWpSXmKPExsXClcIroXtwxplAgy27JS02fbzAZrH+40FW i/9tfxgtrs88x2xxatVdJgdWj56XVxg9ds66y+5xYd80do9FzzayBLBENTDaJObl5ZcklqQq pKQWJ9sq+ReUZObnFXvklxanKrhkFifnJGbmphYpKWSm2CoZKykU5CQmp+am5pXYKiUWFKTm pSjZcSlgABugssw8hdS85PyUzLx0WyXPYH9dCwtTS11DJbt4ZJDQyZKx/vE71oK/zBU791xg b2DsY+5i5OCQEDCR2HEusYuRE8gUk7hwbz1bFyMXh5DAAUaJjcdXQjkrGSVePJjLDFLFK6Av cXnyTTYQm0VAVaLtx1FWEJtNQFdiUv8KsLiQgIpE39kbTCA2v4CwxL4PTWC9ogJhEu+XTWWF mCMocXLmExYQW0RAQ+L810PMIMuYBTYxSiyfPgtskLCApcS15VtYIIauYpZoOWQCYnMK6Eis W90AFmcWsJW4MOc6lC0vsf3tHGaIelWJFc0T2SBeU5D4f+Ud0wRGkVlIds9C0j4LSfsCRuZV jOLFZYnJGZlmBcW5JQVGegWpidlmenmpJZsYQemB6bTCDsbNPVaHGAU4GJV4eCfknwkUYk0s K67MPcQowcGsJMJ7xB8oxJuSWFmVWpQfX1Sak1p8iNEHGGgTmaVEk/OBqSuvJN7Q2NTA1NLU 0NTc1NAIh7CSOO8+pmWBQgLpwPSTnZpakFoEM46Jg1OqgXF71vHsAzV+6qsuRhsvXyaw/ofo s21rzr//7u4mriK/b7GpZ9FOveIVhwLMixo8w57L932Wk85/ss3gaLNu90vdR+IHCwtWSP3h ef7QzNrr/NX25oDL5Vbrzouee3Ox7v3/Wdfvqgcf372CIWd52WaVad8MFzkuSt9aK/QwZL72 iYqyNcFyHPFKLMUZiYZazEXFiQC4RLwYPAMAAA== X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 06/27/2013 02:49 PM, Andrew Dunstan wrote: > But that's a lie, surely. If it breaks you have nobody to blame but > yourself. There's a reason EDB haven't marked their function > immutable - it's not. Well, yeah. That's why I'm testing it in a dev system. :) None of this will probably pan out, but I need to see the limits of how badly I can abuse the database. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-676-8870 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance