Search Postgresql Archives

Re: optimizing server for a 10 million row table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



General consensus is to use 10-25% of server memory for shared_buffers,
but much of that consensus was generated before 8.0, which introduced a
much more sophisticated management scheme for shared_buffers. Basically,
you need to do some testing to see what setting will work best. Reports
back to here or -performance would be appreciated.

On Sat, Jan 21, 2006 at 12:16:04PM -0600, Tony Caduto wrote:
> Hi,
> we have a client that has a table that holds transactions from sales and 
> it is now at 10 million rows. it was in MS Access and they could only 
> hold 2 million rows, so we installed Postgres for them and they dumped 
> 10 million rows from the mainframe into Postgres.
> 
> I was just wondering if anyone had suggestions for optimizing the 
> postgresql.conf file and how much OS shared memory I should 
> reserve(RedHat is set by default to have 128mb of shared memory).
> 
> We are running on RedHat Enterprise Linux 4 AS on a dual processor P4 
> Xeon with 2.5 gb of ram.
> 
> The table in question has 20 fields and I could post the DDL of the 
> table if needed.
> 
> Thanks,
> 
> 
> -- 
> Tony Caduto
> AM Software Design
> Home of PG Lightning Admin for Postgresql
> http://www.amsoftwaredesign.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@xxxxxxxxxxxxx
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux