RT hosting, we've done a bit of it on GPDB systems, but we're not making it
> a focus area. Instead, we do subscription pricing by the amount of data
> used and recommend / help get systems set up.
>
> - Luke
>
> Msg is shrt cuz m on ma treo
>
>
> -O
Nik, you may be underestimating just how much performance can be obtained
from a single database server. For example, an IBM p595 server connected to
an array of ds8300 storage devices could reasonably be expected to provide
several orders of magnitude more performance when compared to commodity
ha
Does anyone here have positive experiences to relate running
fiberchannel cards on FreeBSD on AMD64? The last time I tried it was
with FreeBSD 4 about 2 years ago and none of the cards I tried could
cross the 32bit memory barrier (since they were all actually 32bit
cards despite plugging into a 64b
> 2. I found that using the now() function - and arbitrary interval will
> produce a different execution plan that using a specific date. For example:
> assuming the current time is 16:00:
> a) where start_date > now() - interval '4 hours' scans all child tables.
> b) where start_date >
.
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFBmMnSgfzn5SevSpoRAlp2AKCVXQkZLR7TuGId/OLveHPqpzC4zwCffNFC
I'm about to do a whole bunch of testing here on various DA element
sizes, and datablock sizes and how the affect pg performance. It doesn't
appear possible to get > 4kb filesystem blocks under linux due to the
limitation of the pagesize. We're running AMD64 for these tests, but the
DA configur
ablocks line up with the
filesystem blocks. Any suggestions on this would be greatly appreciated.
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-BEGIN PGP SIGNATURE---
>4 GB memory.
There are dozens of options for the disk array. For the processing
platform, I'd recommend looking at Opteron. I've heard only good things
and their price is much more reasonable than the other options.
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Admi
mount it on
server B and start postgres instance on server B. It gives me some
fail-over capability as well as scalability and a lot of flexibility in
balancing load over multiple servers.
Avoid: paying for brutally expensive FC gear.
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
responding. You seem
like an intelligent guy and you asked an interesting question, but...
| cold feet presents emma
|
| email marketing for discriminating
| ^^^
| organizations everywhere
|
| visit www.myemma.com
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database
(Network Block Device).
Has anyone had any experience with running postgres over either of these
technologies? What issues do we need to know about / pay attention to?
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568
panies that I'm aware of
offer quad Opteron solutions with SATA raid:
http://www.quatopteron.com/
http://alltec.com/home.php
Andrew Hammond
DBA - Afilias
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http:/
12 matches
Mail list logo
