|
Home > Archive > PostgreSQL Discussion > January 2006 > optimizing server for a 10 million row table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
optimizing server for a 10 million row table
|
|
| Tony Caduto 2006-01-21, 1:23 pm |
| 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 2006-01-31, 3:23 am |
| 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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|