"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> I'm departing in three ways from the simple IDE
> model that (I presume) the default random page cost of 4 is based on- The
> disks are SCSI & RAID and the FS would be different.
Actually, the default 4 is based on experiments I did quite awhile back
> ...About one year ago I considered moving to a journaling file system, but
> opted not to because it seems like that's what WAL does for us already. How
> does putting a journaling file system under it add more reliability?
WAL only works if the WAL files are actually written to disk and can be
Nick,
> ...About one year ago I considered moving to a journaling file system, but
> opted not to because it seems like that's what WAL does for us already. How
> does putting a journaling file system under it add more reliability?
It lets you restart your server quickly after an unexpected power
I'm confused:
Ang Chin Han wrote:
> We've been using ext3fs for our production systems. (Red Hat Advanced
> Server 2.1)
Vincent van Leeuwen wrote:
> I'd upgrade to a journaling filesystem as soon as possible for
> reliability.
...About one year ago I considered moving to a journaling file syst
>> > Be sure to mount noatime
>>
>> I did "chattr -R +A /var/lib/pgsql/data"
>> that should do the trick as well or am I wrong?
>>
>
> According to the man page it gives the same effect.
> There are a few things you should consider though:
> - new files won't be created with the same options (I
On 2003-07-18 18:20:55 +0200, Oliver Scheit wrote:
> > Be sure to mount noatime
>
> I did "chattr -R +A /var/lib/pgsql/data"
> that should do the trick as well or am I wrong?
>
According to the man page it gives the same effect. There are a few things you
should consider though:
- new files won
> Be sure to mount noatime
I did "chattr -R +A /var/lib/pgsql/data"
that should do the trick as well or am I wrong?
regards,
Oli
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 2003-07-17 10:41:35 -0500, Nick Fankhauser wrote:
> I'm using ext2. For now, I'll leave this and the OS version alone. If I
>
I'd upgrade to a journaling filesystem as soon as possible for reliability.
Testing in our own environment has shown that PostgreSQL performs best on ext3
(yes, better
On Fri, 18 Jul 2003, Ang Chin Han wrote:
> Shridhar Daithankar wrote:
> > On 17 Jul 2003 at 10:41, Nick Fankhauser wrote:
> >
> >>I'm using ext2. For now, I'll leave this and the OS version alone. If I
> >
> >
> > I appreciate your approach but it almost proven that ext2 is not the best and
>
Thanks for the suggestions in the FS types- especially the Debian oriented
info. I'll start by playing with the memory allocation parameters that I
originally listed (seems like they should provide results in a way that is
unaffected by the disk IO). Then once I have them at optimal values, move o
Shridhar Daithankar wrote:
On 17 Jul 2003 at 10:41, Nick Fankhauser wrote:
I'm using ext2. For now, I'll leave this and the OS version alone. If I
I appreciate your approach but it almost proven that ext2 is not the best and
fastest out there.
Agreed.
IMO, you can safely change that to reiserf
On 17 Jul 2003 at 10:41, Nick Fankhauser wrote:
> I'm using ext2. For now, I'll leave this and the OS version alone. If I
I appreciate your approach but it almost proven that ext2 is not the best and
fastest out there.
IMO, you can safely change that to reiserfs or XFS. Or course, testing is
al
Nick Fankhauser wrote:
Thanks for the correction- it sounds like this is one where usage
can't be precisely controlled in a dynamic user environment & I just
need to get a feel for what works under a load that approximates my
production system.
I think the most important point here is that if you s
> Wrong, actually. Sort memory is allocated *per sort*, not per
connnection or
> per query. So a single complex query could easily use 4xsort_mem if it
has
> several merge joins ...
Thanks for the correction- it sounds like this is one where usage can't be
precisely controlled in a dynamic us
Nick,
> I'll try that approach while testing. Is it the case that the sort memory
> is allocated for each connection and becomes unavailable to other processes
> while the connection exists? If so, since I'm using a connection pool, I
> should be able to control total usage precisely. Without a co
Shridhar-
I appreciate your thoughts- I'll be running some before & after tests on
this using one of our development/hot-swap boxes, so I'll report the results
back to the list.
A few more thoughts/questions:
> 1. 30 users does not seem to be much of a oevrhead. If possible
> try doing away with
On 14 Jul 2003 at 12:51, Nick Fankhauser wrote:
> Any thoughts? Is this a sane plan? Are there other parameters I should
> consider changing first?
Well, everything seems to be in order and nothing much to suggest I guess. But
still..
1. 30 users does not seem to be much of a oevrhead. If possib
17 matches
Mail list logo