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,
maybemore), with
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: [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 11:33
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 /etc/fstab.conf. These are mount settings. man
mount
for more details.
The second
, 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 Leeuwen [EMAIL PROTECTED]
To: [EMAIL PROTECTED
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: [PERFORM] Indexing question
Hi all,
I have some tables (which can get pretty large) in which I want
.
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 -
From: Tom Lane [EMAIL PROTECTED]
To: Alexander Priem
, 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 you searched our
? It 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
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: Alexander Priem [EMAIL PROTECTED]
Cc: [EMAIL
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
?
Thanks for your help so far :)
Kind regards,
Alexander Priem.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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)---
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
regards,
Alexander Priem.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
15 matches
Mail list logo
