Skip site navigation (1) Skip section navigation (2)

Re: How to improve insert speed with index on text column

From: Saurabh <saurabh(dot)b85(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve insert speed with index on text column
Date: 2012-01-30 17:46:21
Message-ID: c67d3789-74c8-4b20-aa2b-451ca0649f71@kn4g2000pbc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thank you for the information.

Schema of table is:

ID                         bigint
company_name     text
data_set                text
time                      timestamp
Date                     date

Length of company_name is not known so it is of datatype text. I need
to build the index on company_name and ID. And then insert the
records. I can not create the index after insertion because user can
search the data as well while insertion.

Machine is of 8 core, os centos6 and 8 GB of RAM.

Here is my configuration:

max_connections = 100
shared_buffers = 32MB
wal_buffers = 1024KB
checkpoint_segments = 3


In response to

Responses

pgsql-performance by date

Next:From: Claudio FreireDate: 2012-01-30 18:20:28
Subject: Re: How to improve insert speed with index on text column
Previous:From: Jeff JanesDate: 2012-01-30 15:24:36
Subject: Re: How to improve insert speed with index on text column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group