 | This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C4FDAD.8EF7F1C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I have the go ahead of a customer to do some testing on Postgresql in a
couple of weeks as a replacement for Oracle.
The reason for the test is that the number of users of the warehouse is
going to increase and this will have a serious impact on licencing costs. (I
bet that sounds familiar)
We're running a medium sized data warehouse on a Solaris box (4CPU, 8Gb RAM)
on Oracle.
Basically we have 2 large fact tables to deal with: one going for 400M rows,
the other will be hitting 1B rows soon.
(around 250Gb of data)
My questions to the list are: has this sort of thing been attempted before?
If so, what where the results?
I've been reading up on partitioned tabes on pgsql, will the performance
benefit will be comparable to Oracle partitioned tables?
What are the gotchas? Should I be testing on 8 or the 7 version?
Thanks in advance for any help you may have, I'll do my best to keep
pgsql-performance up to date on the results.
Best regards,
Matt
___________________________________________
Matt Casters
i-Bridge bvba, http://www.kettle.be
Fonteinstraat 70, 9400 OKEGEM, Belgium
Tel. 054/25.01.37
GSM 0486/97.29.37
------=_NextPart_000_0000_01C4FDAD.8EF7F1C0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
charset=3Dus-ascii">
size=3D2>Hi,
size=3D2>
I have =
the go ahead=20
of a customer to do some testing on Postgresql in a couple of weeks as a =
replacement for Oracle.
The =
reason for the=20
test is that the number of users of the warehouse is going to increase =
and this=20
will have a serious impact on licencing costs. (I bet that sounds=20
familiar)
We're running a medium =
sized data=20
warehouse on a Solaris box (4CPU, 8Gb RAM) on Oracle.
class=3D290252021-18012005>
Basically we have 2 class=3D290252021-18012005>large fact tablesclass=3D290252021-18012005>=20
to deal with: one going for 400M rows, the other will =
be=20
hitting 1B rows soon.
size=3D2>(around 250Gb of=20
data)
size=3D2>
My =
questions to the=20
list are: has this sort of thing been attempted before? If so, what =
where=20
the results?
I've =
been reading up=20
on partitioned tabes on pgsql, will the performance benefit will be =
comparable=20
to Oracle partitioned tables?
What =
are the=20
gotchas? Should I be testing on 8 or the 7 =
version?
size=3D2>
Thanks =
in=20
advance for any help you may have, I'll do my best to keep=20
pgsql-performance up to date on the results.
size=3D2>
Best=20
regards,
size=3D2>
size=3D2>Matt
size=3D2>___________________________________________
Matt Casters
i-Bridge bvba, href=3D"http://www.kettle.be/">http://www.kettle.be
Fonteinstraat 70, =
9400 OKEGEMclass=3D290252021-18012005>, Belgium
Tel. =
054/25.01.37
GSM =
0486/97.29.37
size=3D2>
------=_NextPart_000_0000_01C4FDAD.8EF7F1C0--
|
