Am Donnerstag, 23. Oktober 2003 15:26 schrieb Tom Lane:
> ... if all tuples are the same size, and if you never have any
> transactions that touch enough tuples to overflow your undo segment
> (or even just sit there for a long time, preventing you from recycling
> undo-log space; this is the dual
> "AL" == Allen Landsidel <[EMAIL PROTECTED]> writes:
AL> I recently built a rather powerful machine to be used in a heavily
AL> accessed database.. the machine is a dual AthlonMP 2800+, 2GB of
AL> PC2100 ECC, and a 4x18GB RAID-0 using 15k rpm fujitsu MAS drives on a
AL> 4ch u160 ICP-Vortex ca
> "JB" == Josh Berkus <[EMAIL PROTECTED]> writes:
JB> Medora,
>> Increasing effective_cache_size to 1 did it.
JB> That would be 78MB RAM. If you have more than that available, you can
JB> increase it further. Ideally, it should be about 2/3 to 3/4 of available
JB> RAM.
Assuming you
> "RN" == Rob Nagler <[EMAIL PROTECTED]> writes:
RN> Vivek Khera writes:
>> AMI or Adaptec based?
RN> Adaptec, I think. AIC-7899 LVD SCSI is what dmidecode says, and
RN> Red Hat/Adaptec aacraid driver, Aug 18 2003 is what comes up when it
Cool. No need to diddle with it, then. The Adaptec
Robert Treat wrote:
> On Thu, 2003-10-23 at 11:27, Will LaShell wrote:
> > > Also, I cannot find any list of packages included in Enterprise Linux
> > 2.1 /
> > > 3. Does anyone know if PostgreSQL is included and if so, what version?
> >
> > You have two options as I understand it for PG under RHE
On Thu, 2003-10-23 at 08:44, Robert Treat wrote:
> On Thu, 2003-10-23 at 11:27, Will LaShell wrote:
> > > Also, I cannot find any list of packages included in Enterprise Linux
> > 2.1 /
> > > 3. Does anyone know if PostgreSQL is included and if so, what version?
> >
> > You have two options as I u
On Thu, 2003-10-23 at 11:27, Will LaShell wrote:
> > Also, I cannot find any list of packages included in Enterprise Linux
> 2.1 /
> > 3. Does anyone know if PostgreSQL is included and if so, what version?
>
> You have two options as I understand it for PG under RHEL. You can
> install the PG sour
On Thu, 23 Oct 2003, Alexander Priem wrote:
> I have been searching (www.lsil.com) for this megaraid_2 driver you
> mentioned.
>
> What kind of MegaRaid card does the Perc4/Di match? Elite1600? Elite1650?
>
> I picked Elite1600 and the latest driver I found was version 2.05.00. Is
> this one OK
On Thu, 2003-10-23 at 01:40, Alexander Priem wrote:
> Hi guys,
>
> This basically continues the other thread about the PERC4 RAID controller,
> but since it is a bit off-topic I thought to start another thread. Thanks
> for all your help so far :)
>
> Earlier today I read about the newly releas
Tom Lane writes:
> ... if all tuples are the same size, and if you never have any
Incorrect. If the tuples smaller, Oracle does the right thing. If
there's enough space in the page, it shifts the tuples to make room.
That's what pctfree, pctused and pctincrease allow you to control.
It's all in
On Thu, Oct 23, 2003 at 09:17:41AM -0400, Tom Lane wrote:
>
> Maybe, but only if it actually had reason to use a ton of memory ---
> that is, it were recycling a very large number of tuples in a single
> table. IIRC that didn't seem to be the case here.
Ah, that's what I was trying to ask. I di
Asked and answered on the list probably a thousand times, but what else is
there to discuss on the performance list? :)
I recently built a rather powerful machine to be used in a heavily accessed
database.. the machine is a dual AthlonMP 2800+, 2GB of PC2100 ECC, and a
4x18GB RAID-0 using 15k r
Mario Weilguni <[EMAIL PROTECTED]> writes:
> I think oracle does not do garbage collect, it overwrites the tuples directly
> and stores the old tuples in undo buffers. Since most transactions are
> commits, this is a big win.
... if all tuples are the same size, and if you never have any
transact
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Wed, Oct 22, 2003 at 09:27:47PM -0400, Tom Lane wrote:
>> trace. What is causing that? Not VACUUM I don't think. It doesn't have
>> any huge memory demand. But swapping out processes could account for
> What about if you've set vacuum_mem too hi
On Wed, Oct 22, 2003 at 09:27:47PM -0400, Tom Lane wrote:
> trace. What is causing that? Not VACUUM I don't think. It doesn't have
> any huge memory demand. But swapping out processes could account for
What about if you've set vacuum_mem too high?
A
--
Andrew Sullivan
Hi guys,
This basically continues the other thread about the PERC4 RAID controller,
but since it is a bit off-topic I thought to start another thread. Thanks
for all your help so far :)
Earlier today I read about the newly released RedHat Enterprise Linux ES
version 3. This version should inclu
I have been searching (www.lsil.com) for this megaraid_2 driver you
mentioned.
What kind of MegaRaid card does the Perc4/Di match? Elite1600? Elite1650?
I picked Elite1600 and the latest driver I found was version 2.05.00. Is
this one OK for RedHat 9? The README file present only mentions RedHat8
17 matches
Mail list logo