On Sat, 1 Mar 2008, Franck Routier wrote:
Well, am I just wrong, or the file system might also heavily rely on
cache, especially as I use XFS ? So anyway Postgresql has no way to know
if the data is really on the disk, and in case of a brutal outage, the
system may definitely lose data, wether
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Sat, Mar 1, 2008 at 4:27 AM, Franck Routier <[EMAIL PROTECTED]> wrote:
>> Well, am I just wrong, or the file system might also heavily rely on
>> cache, especially as I use XFS ?
>>
>> So anyway Postgresql has no way to know if the data is really on
On Sat, Mar 1, 2008 at 4:27 AM, Franck Routier <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Le vendredi 29 février 2008 à 23:56 -0500, Greg Smith a écrit :
> > Wording is intentional--if you don't have a battery for it, the cache has
> > to be turned off (or set to write-through so it's only being used
Hi,
Le vendredi 29 février 2008 à 23:56 -0500, Greg Smith a écrit :
> Wording is intentional--if you don't have a battery for it, the cache has
> to be turned off (or set to write-through so it's only being used on
> reads) in order for the database to be reliable. If you can't finish
> writes
On Sat, 1 Mar 2008, Shane Ambler wrote:
It may be the way you have worded this but it makes it sound like the
cache and the battery backup are as one (or that the cache doesn't work
unless you have the battery)...If the raid card has the cache without
the battery you would get the performance
Greg Smith wrote:
On Fri, 29 Feb 2008, Franck Routier wrote:
my Raid controller is an Adaptec 31205 SAS/RAID controller. The battery
was an option, but I didn't know it at purchase time. So I have no
battery, but the whole system is on an UPS.
The UPS is of no help here. The problem is that
Greg Smith wrote:
The only real downside of md RAID is that if you lose the boot device
it can be tricky to get the system to start again; hardware RAID hides
that little detail from the BIOS. Make sure you simulate a failure of
the primary boot drive and are comfortable with recovering from
On Feb 29, 2008, at 9:51 AM, Franck Routier wrote:
my Raid controller is an Adaptec 31205 SAS/RAID controller. The
battery
was an option, but I didn't know it at purchase time. So I have no
battery, but the whole system is on an UPS.
Go find one on ebay or google search, and plug it in. Ad
On Fri, 29 Feb 2008, Joshua D. Drake wrote:
/data1 - RAID 10 journalled filesystem + 1 (so 9 disks)
/xlogs - RAID 1 non journalled filesystem + 1 (so 3 disks)
Sounds good. Can't they share the hot spare, rather than having two?
However, I would recommend splashing out on the battery for the c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Feb 2008 12:17:29 -0500
"Jignesh K. Shah" <[EMAIL PROTECTED]> wrote:
>
>
> Franck Routier wrote:
> > Hi,
> >
> > I am in the process of setting up a postgresql server with 12 SAS
> > disks.
> >
> > I am considering two options:
> >
> > 1)
Franck Routier wrote:
Hi,
I am in the process of setting up a postgresql server with 12 SAS disks.
I am considering two options:
1) set up a 12 disks raid 10 array to get maximum raw performance from
the system and put everything on it (it the whole pg cluster, including
WAL, and every table
On Fri, 29 Feb 2008, Franck Routier wrote:
my Raid controller is an Adaptec 31205 SAS/RAID controller. The battery
was an option, but I didn't know it at purchase time. So I have no
battery, but the whole system is on an UPS.
The UPS is of no help here. The problem is that PostgreSQL forces t
Hi,
my Raid controller is an Adaptec 31205 SAS/RAID controller. The battery
was an option, but I didn't know it at purchase time. So I have no
battery, but the whole system is on an UPS.
I have done quite a few tests using bonnie++, focusing on 'random seek'
results, and found out that:
1) linux
On Fri, Feb 29, 2008 at 5:51 AM, Franck Routier
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am in the process of setting up a postgresql server with 12 SAS disks.
>
> I am considering two options:
>
> 1) set up a 12 disks raid 10 array to get maximum raw performance from
> the system and put everyth
Hi,
I am in the process of setting up a postgresql server with 12 SAS disks.
I am considering two options:
1) set up a 12 disks raid 10 array to get maximum raw performance from
the system and put everything on it (it the whole pg cluster, including
WAL, and every tablespcace)
2) set up 3 raid
15 matches
Mail list logo
