Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: postgresql basic info

Posted on 2010-07-27 12:37:17 by Lazarin Toni

--_000_B50D441546C34D42BBCA74F6E2B7B72B955AED056AS060VS20kap sc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,
I am Oracle DBA and i will be maybe work on a project where postgresql data=
base will be used.
So i would be greatful if you could please advise me on the folowing :


* Estimated time for postgresql latest RDBMS software instalation a=
nd configuration (does it takes longer on windows or on linux)

* Are there any prefered OS, like windows or linux etc ... ?

* Estimated time for import of 50gb of data from older postgres to =
the newly instaled postgres?


Thanks.


The information contained in this e-mail message is privileged and
confidential and is for the exclusive use of the addressee. The person
who receives this message and who is not the addressee, one of his
employees or an agent entitled to hand it over to the addressee, is
informed that he may not use, disclose or reproduce the contents
thereof, and is kindly asked to notify the sender and delete the e-mail
immediately.


--_000_B50D441546C34D42BBCA74F6E2B7B72B955AED056AS060VS20kap sc_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:321933288;
mso-list-type:hybrid;
mso-list-template-ids:1679077562 -1691052922 68812803 68812805 68812801 68=
812803 68812805 68812801 68812803 68812805;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DHR link=3Dblue vlink=3Dpurple>

<div class=3DWordSection1>

<p class=3DMsoNormal>Hello, <o:p></o:p></p>

<p class=3DMsoNormal>I am Oracle DBA and i will be maybe work on a project =
where
postgresql database will be used.<o:p></o:p></p>

<p class=3DMsoNormal>So i would be greatful if you could please advise me o=
n the
folowing :<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoListParagraph style=3D'text-indent:-18.0pt;mso-list:l0 level1=
lfo1'><![if !supportLists]><span
style=3D'font-family:Symbol'><span style=3D'mso-list:Ignore'>&middot;<span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;
</span></span></span><![endif]>Estimated time for postgresql latest RDBMS
software instalation and configuration (does it takes longer on windows or =
on
linux)<o:p></o:p></p>

<p class=3DMsoListParagraph style=3D'text-indent:-18.0pt;mso-list:l0 level1=
lfo1'><![if !supportLists]><span
style=3D'font-family:Symbol'><span style=3D'mso-list:Ignore'>&middot;<span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;
</span></span></span><![endif]>Are there any prefered OS, like windows or l=
inux
etc ... ?<o:p></o:p></p>

<p class=3DMsoListParagraph style=3D'text-indent:-18.0pt;mso-list:l0 level1=
lfo1'><![if !supportLists]><span
style=3D'font-family:Symbol'><span style=3D'mso-list:Ignore'>&middot;<span
style=3D'font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;
</span></span></span><![endif]>Estimated time for import of 50gb of data fr=
om
older postgres to the newly instaled postgres?<o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-left:18.0pt'><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal style=3D'margin-left:18.0pt'><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal style=3D'margin-left:18.0pt'>Thanks.<o:p></o:p></p>

</div>

</body>

</html>

<p>

The information contained in this e-mail message is privileged and<br>
confidential and is for the exclusive use of the addressee. The person<br>
who receives this message and who is not the addressee, one of his<br>
employees or an agent entitled to hand it over to the addressee, is<br>
informed that he may not use, disclose or reproduce the contents<br>
thereof, and is kindly asked to notify the sender and delete the e-mail<br>
immediately.<br>
<br>
<br>
</p>
--_000_B50D441546C34D42BBCA74F6E2B7B72B955AED056AS060VS20kap sc_--

Report this message

#2: Re: postgresql basic info

Posted on 2010-07-27 22:34:14 by Craig James

On 7/27/10 3:37 AM, Lazarin Toni wrote:
> I am Oracle DBA and i will be maybe work on a project where postgresql
> database will be used.
>
> So i would be greatful if you could please advise me on the folowing :
>
> =B7 Estimated time for postgresql latest RDBMS software instalation and
> configuration (does it takes longer on windows or on linux)

Most of your time will be spent wondering what you've overlooked, thinkin=
g it couldn't possibly be that simple.

Seriously, if you know Linux or BSD admin, you can download it from sourc=
e, compile and have a working database in about 30 minutes. If your dist=
ro has Postgres, then your installation time is zero.

You'll spend some time tuning your configuration file for your particular=
needs. The postgres-performance mailing is a good place to ask this que=
stion.

The most important considerations are common to both Postgres and Oracle.=
That is, what kind of hardware do you have, and is it sufficient to you=
r workload? CPUs, disks, memory, RAID config, and so on. That's also a =
question for the postgres-performance mailing list.

> =B7 Are there any prefered OS, like windows or linux etc ... ?

BSD or Linux. Windows is considered a second-tier platform for Postgres.

> =B7 Estimated time for import of 50gb of data from older postgres to th=
e
> newly instaled postgres?

Depends a lot on your hardware, and also on the nature of the data (lots =
of indexes will add time). It also depends how you do it. pg_dump/pg_re=
store are pretty fast. This would probably take a few hours on a reasona=
ble mid-sized server, for example, with an 8-disk RAID 10 array with a ba=
ttery-backed RAID controller.

Craig

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Report this message

#3: Re: postgresql basic info

Posted on 2010-07-27 22:49:54 by Kevin Grittner

Lazarin Toni <Toni.Lazarin@kapsch.net> wrote:

> * Estimated time for postgresql latest RDBMS software instalation
> and configuration (does it takes longer on windows or on linux)

That depends. On a kubuntu system which didn't have PostgreSQL
installed, I typed:

sudo apt-get install postgresql

I had a running cluster in about 50 seconds. On the other hand,
when I'm going to install a new major release for our production
system, I read up on it, download source, build the core product and
our home-grown extensions, and test that everything seems to be
working OK. Just the builds and basic tests can take an hour. At
least half that is because of our home-grown extensions, though.
The study and the tests of our applications is very dependent on the
specific changes in the new release.

> * Are there any prefered OS, like windows or linux etc ... ?

I think the best benchmarks I've seen have been on FreeBSD, although
I think Linux is more popular. I would stay away from Windows. It
seems as though AIX and Solaris tend to have more build issues with
special packages than some.

> * Estimated time for import of 50gb of data from older postgres
> to the newly instaled postgres?

That's going to depend on the hardware, line speed (if across the
wire), OS, configuration, etc. Ballpark, for our databases and
hardware a 50GB pg_dump | psql load (the normal route for major
version upgrade) would take 30 to 40 minutes. We use a different
configuration for such a conversion or bulk load, and then
reconfigure for production; this allows us to turn off fsync and
full page writes for the load, which would not be safe for normal
use.

-Kevin


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Report this message