On 2 Feb 2004 at 16:45, scott.marlowe wrote:
> Do you have the cache set to write back or write through? Write through
> can be a performance killer. But I don't think your RAID is the problem,
> it looks to me like postgresql is doing a lot of I/O. When you run top,
> do the postgresql proc
On Mon, 2 Feb 2004, Kevin Barnard wrote:
> On 2 Feb 2004 at 13:58, scott.marlowe wrote:
>
> > what do you mean at 2 GB? Is that how much is in kernel cache plus
> > buffer, plus used, plus etc??? Could you give us the top of top output to
> > make sure? If most of that is kernel cache, then
On 2 Feb 2004 at 13:58, scott.marlowe wrote:
> what do you mean at 2 GB? Is that how much is in kernel cache plus
> buffer, plus used, plus etc??? Could you give us the top of top output to
> make sure? If most of that is kernel cache, then that's fine.
2GB was total system memory. We upg
On Mon, 2 Feb 2004, Kevin Barnard wrote:
> I am running a Dual Xeon hyperthreaded server with 4GB RAM RAID-5. The only
> thing running on the server is Postgres running under Fedora. I have a 700
> connection limit.
>
> The DB is setup as a backend for a very high volume website. Most of the
On Monday 02 February 2004 19:39, Qing Zhao wrote:
> I am new here. I have a question related to this in some way.
Hmm - no real connection I can see - might have been better to start a new
thread rather than replying to this one. Also, it is usually considered best
practice not to quote large a
On Mon, 2 Feb 2004, Qing Zhao wrote:
> I am new here. I have a question related to this in some way.
>
> Our web site needs to upload a large volume of data into Postgres at a
> time. The performance deterioates as number of rows becomes larger.
> When it reaches 2500 rows, it never come back
I am new here. I have a question related to this in some way.
Our web site needs to upload a large volume of data into Postgres at a
time. The performance deterioates as number of rows becomes larger.
When it reaches 2500 rows, it never come back to GUI. Since the tests
were run through GUI, m
I am running a Dual Xeon hyperthreaded server with 4GB RAM RAID-5. The only
thing running on the server is Postgres running under Fedora. I have a 700
connection limit.
The DB is setup as a backend for a very high volume website. Most of the queries
are simple, such as logging accesses, user
