> On Thu, 5 Nov 1998, G. Anthony Reina wrote:
>
> > Marc,
> >
> >
> > I'm running PostgreSQL v. 6.3.2. No I don't want to disable
> > fsync just in case someone stops a process midstream (which has
> > happened before-- I figure it could screw up the db). So maybe it is
> > those "memor
On Thu, 5 Nov 1998, David Ben-Yaacov wrote:
> Even under normal operations when the database is fast, we still have
> problems inserting data. We have examined the insert query identified
> in our error log to see if there is a problem with our code.
> Apparently not, as the insert query that
On Thu, 5 Nov 1998, G. Anthony Reina wrote:
> Marc,
>
>
> I'm running PostgreSQL v. 6.3.2. No I don't want to disable
> fsync just in case someone stops a process midstream (which has
> happened before-- I figure it could screw up the db). So maybe it is
> those "memory leaks" that
> On the memory issue, I'm running PII-300's with 128MB of RAM.
> while memory is always full (this machine is also running bind)
> and has stuff swapped, there is actually very little swapping
> there is actually very little swapping going on.
Full memory does automatically mean swapping is goi
Marc,
I'm running PostgreSQL v. 6.3.2. No I don't want to disable fsync just
in case someone stops a process midstream (which has happened before-- I
figure it could screw up the db). So maybe it is those "memory leaks"
that you've suggested. I'll try closing and re-connecting to
TECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; Tony Reina
<[EMAIL PROTECTED]>
Date: Wednesday, November 04, 1998 9:24 PM
Subject: Re: seperate swap drive, was Re: [ADMIN] Speed problem
>On Wed, 4 Nov 1998, Terry Mackintosh wrote:
>
>> > I have a rather large databas
Hi,
> You can use several swap partittions with different priorities
You can use 8 swap partitions => 1 GB de swap.
You can use raid0 (stripping) to speed up your database. Imagine you
have 5 HD's and your file is a little here, a little there permiting
you to access data in parallel.
>> Small question, doesn't linux only use around 128 Megs tops for swap
>> space? I thought I read this in a HOWTO somewhere.
>
> If it does, I'll have to add that to my list of reasons why Linux
>is a bad operating system :)
That was the limit of ONE swap partition/file. You can have many swap
On Thu, 5 Nov 1998, The Hermit Hacker wrote:
> Date: Thu, 5 Nov 1998 09:03:57 -0400 (AST)
> From: The Hermit Hacker <[EMAIL PROTECTED]>
> To: Lincoln Spiteri <[EMAIL PROTECTED]>
> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: Re: seperat
After conferring with Jan Weick I removed the index I had on the
database in question and that seems to have solved my problem.
A corrupt index is a bad thing.
On the memory issue, I'm running PII-300's with 128MB of RAM.
while memory is always full (this machine is also running bind)
and has st
On Thu, 5 Nov 1998, Lincoln Spiteri wrote:
> > > I have a rather large database as well (> 2 Meg of tuples). I thought
> > > my system was souped up enough: PII/400 MHz (100 MHz bus) 256 Meg SDRAM,
> > > 18 Gig SCSI harddrive, Red Hat Linux 5.1. However, my swap space (512
> > > Meg) is on th
> > I have a rather large database as well (> 2 Meg of tuples). I thought
> > my system was souped up enough: PII/400 MHz (100 MHz bus) 256 Meg SDRAM,
> > 18 Gig SCSI harddrive, Red Hat Linux 5.1. However, my swap space (512
> > Meg) is on the same harddrive as the database (albeit on a separa
On Wed, 4 Nov 1998, Terry Mackintosh wrote:
> > I have a rather large database as well (> 2 Meg of tuples). I thought
> > my system was souped up enough: PII/400 MHz (100 MHz bus) 256 Meg SDRAM,
> > 18 Gig SCSI harddrive, Red Hat Linux 5.1. However, my swap space (512
> > Meg) is on the same
Hi Tony and all
Well, first I want to say that none of my databases are bigger then a few
meg of data, so I may not be the most experianced here.
That said ...
On Wed, 4 Nov 1998, Tony Reina wrote:
> Terry Mackintosh wrote:
>
> > Note, with a table that big your swap space should be on a phys
Hi all
Ah... \d tablename should return before you can get your finger off the
enter key, as it (I would think) queries a small house keeping table that
contains the database structure, NO? So \d tablename should be totally
independent of the amount of data in that table.
I have never had a tab
On Tue, 3 Nov 1998 The Hermit Hacker wrote:
> On Tue, 3 Nov 1998, Roger Books wrote:
>
> > I have a database that I need to pull the schema off of. When
> > I run pg_dump -s the machine rolls over and dies. To the tune
> > of I left it running over the weekend and still had 98% cpu
> > usage by
On Tue, 3 Nov 1998, Roger Books wrote:
> I have a database that I need to pull the schema off of. When
> I run pg_dump -s the machine rolls over and dies. To the tune
> of I left it running over the weekend and still had 98% cpu
> usage by postgress monday. I managed to do a 'delete from stati
I have a database that I need to pull the schema off of. When
I run pg_dump -s the machine rolls over and dies. To the tune
of I left it running over the weekend and still had 98% cpu
usage by postgress monday. I managed to do a 'delete from statistics'
and it accomplished this overnight, but w
18 matches
Mail list logo
