Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XZ2b5-0006fr-RP for pgsql-admin@arkaria.postgresql.org; Tue, 30 Sep 2014 18:56:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XZ2b4-0007Ue-Gl for pgsql-admin@arkaria.postgresql.org; Tue, 30 Sep 2014 18:56:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XYiAR-00059o-MH for pgsql-admin@postgresql.org; Mon, 29 Sep 2014 21:07:35 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XYiAO-0007fD-IO for pgsql-admin@postgresql.org; Mon, 29 Sep 2014 21:07:33 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1XYiAN-0004yu-PW for pgsql-admin@postgresql.org; Mon, 29 Sep 2014 14:07:31 -0700 Date: Mon, 29 Sep 2014 14:07:31 -0700 (PDT) From: DrakoRod To: pgsql-admin@postgresql.org Message-ID: <1412024851783-5821010.post@n5.nabble.com> In-Reply-To: References: <1411680008162-5820572.post@n5.nabble.com> Subject: Re: The tables partitioning affects the indexes? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 1.8 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Ok! The master table many tuples, so the queries become very slow, we need partitioning it because the table is huge. Is for that my question. So we create indexes and permissions in the child tables! Thank you! ----- Dame un poco de fe, eso me bastar=C3=A1. Rozvo Ware Solutions=20 -- View this message in context: http://postgresql.1045698.n5.nabble.com/The-t= ables-partitioning-affects-the-indexes-tp5820572p5821010.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin