Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgA3c-0003bq-1J for pgsql-performance@arkaria.postgresql.org; Wed, 05 Dec 2012 08:10:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TgA3b-0006oN-3b for pgsql-performance@arkaria.postgresql.org; Wed, 05 Dec 2012 08:10:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgA3a-0006o9-Et for pgsql-performance@postgresql.org; Wed, 05 Dec 2012 08:10:14 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TgA3Y-0001oE-FG for pgsql-performance@postgresql.org; Wed, 05 Dec 2012 08:10:13 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TgA3W-0005zJ-Td for pgsql-performance@postgresql.org; Wed, 05 Dec 2012 00:10:10 -0800 Date: Wed, 5 Dec 2012 00:10:10 -0800 (PST) From: "suhas.basavaraj12" To: pgsql-performance@postgresql.org Message-ID: <1354695010903-5735127.post@n5.nabble.com> Subject: CREATING INDEX on column having null values MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.8 (/) 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 Hi, I have a partitioned table(partitioned on date) .There are about 1 million insertions per day. There is a column called mess_id. This column is updated .But update query is taking huge time.When i checked , this column is not unique, and most of the time its having null . Say everyday out of 1 million only 20K rows are not null for this column ;.Insertions are happening very fast , but update is very slow. How to optimize my update query? Is it good to create index on that column .. i m worried about my insertions getting slow Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/CREATING-INDEX-on-column-having-null-values-tp5735127.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance