Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YIIvY-0000dR-Ms for pgsql-admin@arkaria.postgresql.org; Mon, 02 Feb 2015 15:28:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YIIvY-0006Be-6M for pgsql-admin@arkaria.postgresql.org; Mon, 02 Feb 2015 15:28:40 +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 1YIIvW-00068h-Dg for pgsql-admin@postgresql.org; Mon, 02 Feb 2015 15:28:38 +0000 Received: from nm19-vm2.bullet.mail.ne1.yahoo.com ([98.138.91.95]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YIIvS-0001Mf-8a for pgsql-admin@postgresql.org; Mon, 02 Feb 2015 15:28:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s2048; t=1422890912; bh=sgkaacZAFaADHVNT4FuWxOTxeXmV5yR5VHjWzss46II=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=YK8koaMbo4uGlJ4XZSPgPBi3D4ajd8nQCfzb/6e5s/EC7H16fu7LAZRpYSvU8zPB1UDGIZFrwXFFXtk11AGHpLUyosI1EQWYSXbXmhJ2M3cPkoIN4HqTCalSmkXToZUxbe8CIDTc4MP/wFtmNqGYEaY9/kbhdvPjpUURJRxLJfzIGuUHQDZjb3EAskt3+QQ1jPMjh/pN3GmpHFNdYCKd1884byrh72wzqytjXmeZzN6AW5wRMyipvbrlxh8SiNZbwv2BrzWpY3uOMyjDfO+cngeuhcR6dBhZAZg923Ks+UE/ps3vpa0kjHS67t3dpaHDjG3OBKH3hxe8lxrY2XWALA== Received: from [98.138.100.113] by nm19.bullet.mail.ne1.yahoo.com with NNFMP; 02 Feb 2015 15:28:32 -0000 Received: from [98.138.226.168] by tm104.bullet.mail.ne1.yahoo.com with NNFMP; 02 Feb 2015 15:28:32 -0000 Received: from [127.0.0.1] by omp1069.mail.ne1.yahoo.com with NNFMP; 02 Feb 2015 15:28:32 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 558698.5769.bm@omp1069.mail.ne1.yahoo.com X-YMail-OSG: slYxMd4VM1m5PQzVwKbM_BlcFYnn31xvdlWYrGnMAJ1ohVxbf3CTvZ0ObTuZduB l8G28V6JSDODNIz0ElJr0IFu4dz2pb7Y0g78yRY4DtLTcRaL6MgdlkrCvqanVh_tfYO5gEUUhJ0i NOPG6eReYq61IhWdr2KIP79risJKwUOIfikc_OWryGX5DY5klXPpsxScq6IoESnYrw5l1GJYU4m9 Xnbg24CdyWebJInXnRUW9fYs3Pw2c8qkEurOaJ9smdCZBG52uMfBVNJHomkul0lEkrA3DMHeWSs_ VviGg7yxZIQPuKrwvWGyCJB2tv0gYHgexpFk731Y3MJ6oEWKhRpYWfnr0zsjfpVOC_q8P_F7AoR_ 86qayyTfGqZDtDi4KWyrfYXfJzNHmnASwff.88_JI3yV6D2RDc5zomsW_Ir0GztgzRo2tiYhnYSu iPgpKOQ6A_v4d8W9Ls8rslcpnhNwO5g3BvVrroemDI5drTy18mUOyQDnYhQMCo2W.lqbdVDOi7S6 a_iN5GJO.mSsktRjXNyZKok4nMG3F5LbyKN86CmPjP35CAQtSbJnIIAuYXdAfLYxWl4hleVuIOxk 1YDktjiV47AdGrUTxLIEbGvH08QIn5b8Tr_u4WjGiZacU1bE5swHboJTh9DgabuXs57abxuNb6eI su0MZnzJ9.Sy1o6s6LyCkAvmzBkVB_r5.o_pycur1THxqhvw- Received: by 98.138.105.196; Mon, 02 Feb 2015 15:28:32 +0000 Date: Mon, 2 Feb 2015 15:28:30 +0000 (UTC) From: Kevin Grittner Reply-To: Kevin Grittner To: Naresh Soni Cc: "pgsql-admin@postgresql.org" Message-ID: <1838847801.550314.1422890910146.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: Hi Community MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 762 X-Pg-Spam-Score: -2.0 (--) 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 Naresh Soni wrote: > So you mean postgres can handle such huge records without any > fine tuning required on postgres For any non-trivial database you will certainly need to make adjustments to the configuration files, and probably to the OS, too. You may want to pay for some advice from one of the companies with people experienced in tuning PostgreSQL, but you can get a good start on things with the advice on this Wiki page: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server You should also familiarize yourself with the PostgreSQL documentation on the topic: http://www.postgresql.org/docs/current/interactive/runtime-config.html -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin