Kind regards,
Alexander Priem.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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
So I guess the PERC4/Di RAID controller is pretty good. It seems that
RedHat9 supports it out-of-the-box (driver 1.18f), but I gather from the
sites mentioned before that upgrading this driver to 1.18i would be
better...
---(end of broadcast)---
TIP
I have considered Opteron, yes. But I think there are too many
uncertainties, like :
* It's a new CPU that has not proven itself yet.
* I don't think I can buy directly from IBM (according to their site), so
how about support (24x7) ? This will be very important to our client.
* I need to install
this task?
Thanks for your help so far :)
Kind regards,
Alexander Priem.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Even better than the four-disk NAS I mentioned earlier is the following:
Promise UltraTrak RM8000. This is a so-called SCSI-to-IDE RAID system.
Basically it's a RAID setup of eight IDE disks, using a hardware RAID
engine, that's connected to (in this case) the PostgreSQL server via a SCSI
Ultra160
r and easier
to maintain...
About clustering: I know this can't be done by hooking multiple postmasters
to one and the same NAS. This would result in data corruption, i've read...
Kind regards,
Alexander.
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To:
would be much
cheaper...
Any advice on this would be appreciated :)
Kind regards,
Alexander Priem.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
cs, StorageInfo, PackagingInfo tables would map one to one to records
in the Product table.
Do any of you know if and how PostgreSQL would prefer one approach over the
other?
Thanks in advance,
Alexander Priem.
---(end of broadcast)---
TIP 6: Have y
set to today's date.
If a record gets 'updated', a new record is made containing the new data,
and the old record is marked as 'deleted'.
So the percentage of 'deleted' records will grow with time, if you
understand what I mean.
- Original Message -----
Fr
t?
Does anyone know whether it is bad practise to have two indexes on the
primary key of a table? (one 'primary key' index and one partial index)
- Original Message -
From: "Tomasz Myrta" <[EMAIL PROTECTED]>
To: "Alexander Priem" <[EMAIL PROTECTED]>
n the table?
There would be a double index on the primary key this way, right?
Thanks for your advice so far,
Alexander Priem.
- Original Message -----
From: "Tomasz Myrta" <[EMAIL PROTECTED]>
To: "Alexander Priem" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTE
d of
thing, I think (theoretically at least)?
Kind regards,
Alexander Priem.
- Original Message -
From: "Tomasz Myrta" <[EMAIL PROTECTED]>
To: "Alexander Priem" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 9:03 AM
Subject: Re
a DATE in the case of a deleted record?
I could then index the field 'deleteddate' and create a view with where clause
'Where deleteddate is null'.
Would this give the same performance as my current
solution (with an indexed boolean field 'deleted') ?
I cannot test this myself at the moment as I am
still in a design phase and do not have a real server available
yet...
Thanks in advance,
Alexander Priem
this. My Db would be mostly 'selecting',
but there would also be pretty much inserting and updating done. But most of
the work would be selects. So would this config be OK?
Kind regards,
Alexander.
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
fig? It may not
be the fastest, but a server like this will cost about 4750 euros, and that
is including an Intel Xeon 2.4GHz cpu, redundant power supply, WITHOUT the
UPS. Seems very reasonable to me...
Kind regards,
Alexander Priem.
---(end of broadcast)
fig? It may not
be the fastest, but a server like this will cost about 4750 euros, and that
is including an Intel Xeon 2.4GHz cpu, redundant power supply, WITHOUT the
UPS. Seems very reasonable to me...
Kind regards,
Alexander Priem.
- Original Message -
From: "Vincent van Leeuw
Kind regards,
Alexander Priem.
- Original Message -
From: "Vincent van Leeuwen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 6:28 PM
Subject: Re: [PERFORM] Tuning PostgreSQL
> On 2003-07-21 09:06:10 -0700, Josh Berkus wrote:
> &g
e data and the WAL on one volume...
Thanks for all your help so far.
Kind regards,
Alexander Priem.
- Original Message -
From: "Roman Fail" <[EMAIL PROTECTED]>
To: "Alexander Priem" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTE
ng PostgreSQL
> On 21 Jul 2003 at 13:45, Alexander Priem wrote:
>
> > So where can I set the noatime & data=writeback variables? They are not
> > PostgreSQL settings, but rather Linux settings, right? Where can I find
> > these?
>
> These are typicaly set in /e
So where can I set the noatime & data=writeback variables? They are not
PostgreSQL settings, but rather Linux settings, right? Where can I find
these?
Kind regards,
Alexander Priem.
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: <[EMAIL P
Thanks, I will look at the site you sent me and purchase some hardware. Then
I will run some benchmarks.
Kind regards,
Alexander.
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: "Alexander Priem" <[EMAIL PROTECTED]>
Cc: <[EMAI
Hi guys,
I am new to PostgreSQL and have done some
"extensive" research already. If you could give me some advice/confirmation, I
would be really grateful.
I am going to build a PostgreSQL database server
for a client. This database will contain many tables (over 100,
maybe more), with s
23 matches
Mail list logo
