On 8 Aug 2003 at 12:28, mixo wrote:
> I have just installed redhat linux 9 which ships with Pg
> 7.3.2. Pg has to be setup so that data inserts (blobs) should
> be able to handle at least 8M at a time. The machine has
> two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and
> a 36 Gig hd with 1 G
On Fri, Aug 08, 2003 at 03:34:44PM -0400, Bruce Momjian wrote:
>
> It is true that ext2 isn't good because the file system may not recover,
> but BSD UFS isn't a journalled file system, but does guarantee file
> system recovery after a crash --- it is especially good using soft
> updates.
Sorry.
> > Agreed.. WAL cannot recover something when WAL no longer exists due to a
> > filesystem corruption.
>
> It is true that ext2 isn't good because the file system may not recover,
> but BSD UFS isn't a journalled file system, but does guarantee file
> system recovery after a crash --- it is espec
scott.marlowe wrote:
On Thu, 7 Aug 2003, Yaroslav Mazurak wrote:
Shridhar Daithankar wrote:
That's a nice theory, but it doesn't work out that way. About every two
months someone shows up wanting postgresql to use all the memory in their
box for caching and we wind up explaining that the kern
On Fri, 2003-08-08 at 14:53, Andrew Sullivan wrote:
> On Fri, Aug 08, 2003 at 09:40:20AM -0700, Jonathan Gardner wrote:
> >
> > Redhat puts ext3 on by default. Consider switching to a non-journaling FS
> > (ext2?) with the partition that holds your data and WAL.
>
> I would give you exactly the
Hi All!
Shridhar Daithankar wrote:
On 7 Aug 2003 at 10:05, Yaroslav Mazurak wrote:
It needs to reflect how much cache the system is using - try the "free"
command to see figures.
I'm not found "free" utility on FreeBSD 4.7. :(
Grr.. I don't like freeBSD for it's top output.Active/inactive/
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is
109M.
Scott
On Tue, 2003-08-05 at 11:01, Scott Cain wrote:
> Joe,
>
> Good idea, since I may not get around to profiling it this week. I
> created a dump of the data set I was working with. It is available at
> http://www.gm
