Re: performance issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: DHSC Webmaster <webmaster(at)dhs-club(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance issues
Date: 2001-06-13 14:29:33
Message-ID: 26282.992442573@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

DHSC Webmaster <webmaster(at)dhs-club(dot)com> writes:
> We are running 7.0.3 on a RH 7.0 box w/twin 733 pentium CPUs, 512 meg.
> ram and a 3 drive raid 5 scsi array. The machine is dedicated. Our main
> table is about 700,000 rows with an associated table of about 15,000
> rows.
> -N 128 -B 256

That's not nearly enough buffers for an installation that size. Try -B
of a few thousand.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nicolas Kowalski 2001-06-13 15:56:41 Re: User rights
Previous Message Tom Lane 2001-06-13 14:24:43 Re: User rights

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2001-06-13 14:57:02 Re: [SQL] ORDER BY what?
Previous Message Vivek Khera 2001-06-13 14:20:05 Re: How to store a linked list in a RDBMS