Search Postgresql Archives

Performance large tables.

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

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Performance large tables.
From: Benjamin Arai <barai@xxxxxxxxxx>
Date: Sat, 10 Dec 2005 15:22:47 -0800
In-reply-to: <dnfmdq$ore$1@xxxxxxxxxxxx>
References: <439B3A1D.7060508@xxxxxxxxxx> <dnfmdq$ore$1@xxxxxxxxxxxx>
User-agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)

My issue actually stems from the fact that I cannot do large weeklyupdates on fast enough to meet a weekend window for the following workweek. I am currently using a machine with a raid 1, 4GB RAM, and dualopteron. I could go 0+1 but peroformance increase is only about 20%from the benchmarks I have read. ANY suggestions would be greatlyappreciated.

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

Follow-Ups:
- Re: Performance large tables.
  - From: Martijn van Oosterhout

References:
- Maximum number of tables per database and slowness
  - From: Benjamin Arai
- Re: Maximum number of tables per database and slowness
  - From: William Yu

Prev by Date: Re: tsearch2: How to use different configurations for two
Next by Date: Re: Performance large tables.
Previous by thread: Re: Maximum number of tables per database and slowness
Next by thread: Re: Performance large tables.
Index(es):
- Date
- Thread

[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