Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BE59163221E for ; Wed, 7 Jan 2009 11:53:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47979-09 for ; Wed, 7 Jan 2009 11:53:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from depesz.com (depesz.com [78.46.78.198]) by mail.postgresql.org (Postfix) with ESMTP id 4136863221B for ; Wed, 7 Jan 2009 11:53:14 -0400 (AST) Received: from depesz by depesz.com with local (Exim 4.69) (envelope-from ) id 1LKaiT-0002t2-6E; Wed, 07 Jan 2009 16:53:09 +0100 Date: Wed, 7 Jan 2009 16:53:09 +0100 From: hubert depesz lubaczewski To: Gustavo Rosso Cc: pgsql-general@postgresql.org Subject: Re: explain Message-ID: <20090107155309.GA10593@depesz.com> Reply-To: depesz@depesz.com References: <4964D8BE.7080506@sadaic.org.ar> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4964D8BE.7080506@sadaic.org.ar> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/131 X-Sequence-Number: 142216 On Wed, Jan 07, 2009 at 01:30:54PM -0300, Gustavo Rosso wrote: > Es 1.213ms un valor correcto para realizar un insert en una tabla > obtenido por explain analyze. trochę długo, ale to zależy od sprzętu. dodatkowo - może masz tam triggery? klucze obce? ciężko powiedzieć. pokaż schemat tabeli i tego inserta to coś więcej będziemy mogli powiedzieć. depesz p.s. as you can clearly see from another mails from this list - the list uses english language. please use it, or if you'd like to use spanish (i'm not sure if your language if spanish, i don't know it) - you can use list pgsql-es-ayuda (http://archives.postgresql.org/pgsql-es-ayuda/). -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007