[Spacewalk-list] Migration from pgsql to oracle

Fri Nov 21 05:43:56 UTC 2014

I'll consult partition with my db team. Thanks for suggestion.

2014-11-19 16:50 GMT+01:00 Paul Robert Marino <prmarino1 at gmail.com>:

> Have you considered using a less drastic approach like partitioning
> some of the tables and tuning the ram.
> I some how doubt the single CPU core per query it the problem because
> PostgreSQL is very good at handling bulk queries as opposed to lots of
> queries for tiny data sets.
>
> Here is something you can check if  a directory named
> /var/lib/pgsql/data/pg_tmp exist on your system then your queries are
> exceeding the allowed rem for a single query and PostgreSQL is using
> that directory to essentially create swap files for queries if that is
> happening you need more ram or you need to tune your PostgreSQL
> server.
>
> Here is a good place to start reading about table partitions
> https://wiki.postgresql.org/wiki/Table_partitioning that with
> constraint exclusion enabled in the config can help a lot with large
> data sets.
>
>
>
>
>
>
>
>
>
> On Wed, Nov 19, 2014 at 10:02 AM, Krzysztof Pawłowski
> <msciciel at msciciel.eu> wrote:
> > Ofcourse. But i'll will be planned propably for january. I'll give
> feedback
> > if we encounter problems or not.
> >
> > 2014-11-19 15:49 GMT+01:00 Nahelou Sébastien
> > <sebastien.nahelou at worldline.com>:
> >>
> >> Hello
> >>
> >>
> >>
> >> I’m very interesting about your migration. Could you please give your
> >> feedback when your database migration will be done ?
> >>
> >>
> >>
> >> Thanks
> >>
> >>
> >>
> >> De : spacewalk-list-bounces at redhat.com
> >> [mailto:spacewalk-list-bounces at redhat.com] De la part de Krzysztof
> Pawlowski
> >> Envoyé : mercredi 19 novembre 2014 15:41
> >> À : spacewalk-list at redhat.com
> >> Objet : Re: [Spacewalk-list] Migration from pgsql to oracle
> >>
> >>
> >>
> >> 1. I read that oracle is performing much better in bigger spacewalk
> >> deployment. I have 1600 clients connected to spacewalk and is
> impossible to
> >> schedule tasks on all hosts. My db team said that pgsql is limited to
> single
> >> core per connections which means that spacewalk cannot utilize db in
> more
> >> efficient way. Maybe (I hope) i'm not aware of configuration options
> which
> >> make this possible ?
> >>
> >> We have oracle support so another instance is not a problem for us. I'll
> >> try test export import with db-control.
> >>
> >>
> >>
> >> 2014-11-19 12:54 GMT+01:00 Waldirio Manhães Pinheiro <
> waldirio at gmail.com>:
> >>
> >> Hello Krzysztof,
> >>
> >>
> >>
> >> I see, I've one question for you.
> >>
> >>
> >>
> >> 1. Why do you want change from postgresql to Oracle db ?!, do you have
> >> Oracle support !? Just because I'm curious :-)
> >>
> >>
> >>
> >> What you can do is, build a new machine with SW and Oracle to test,
> export
> >> from SW with postgresql using db-control and import in SW with Oracle
> using
> >> db-control. In theory, the data model is the same changing only the
> sgdb, so
> >> will not get problem about data.
> >>
> >>
> >>
> >> Let me know if you have any doubt about it.
> >>
> >>
> >>
> >>
> >> ______________
> >> Atenciosamente
> >> Waldirio
> >> msn: waldirio at gmail.com
> >> Skype: waldirio
> >> Site: www.waldirio.com.br
> >> Blog: blog.waldirio.com.br
> >>
> >> LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
> >> PGP: www.waldirio.com.br/public.html
> >>
> >>
> >>
> >> On Wed, Nov 19, 2014 at 9:20 AM, Krzysztof Pawłowski
> >> <msciciel at msciciel.eu> wrote:
> >>
> >> I know that I can but problem is that my spacewalk has 1000+ clients and
> >> is using pgsql as db backend now.
> >>
> >>
> >>
> >> 2014-11-19 12:08 GMT+01:00 Waldirio Manhães Pinheiro <
> waldirio at gmail.com>:
> >>
> >> Hello Krzysztof, good morning
> >>
> >>
> >>
> >> you can use Oracle as backend
> >> (https://fedorahosted.org/spacewalk/wiki/HowToInstall#Databaseserver)
> >>
> >>
> >>
> >> B'Regards
> >>
> >>
> >>
> >>
> >> ______________
> >> Atenciosamente
> >> Waldirio
> >> msn: waldirio at gmail.com
> >> Skype: waldirio
> >> Site: www.waldirio.com.br
> >> Blog: blog.waldirio.com.br
> >>
> >> LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
> >> PGP: www.waldirio.com.br/public.html
> >>
> >>
> >>
> >> On Wed, Nov 19, 2014 at 7:42 AM, Krzysztof Pawłowski
> >> <msciciel at msciciel.eu> wrote:
> >>
> >> Is there any way to switch db backend to oracle ?
> >>
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
> >>
> >>
> >>
> >>
> >> ________________________________
> >>
> >> Ce message et les pièces jointes sont confidentiels et réservés à
> l'usage
> >> exclusif de ses destinataires. Il peut également être protégé par le
> secret
> >> professionnel. Si vous recevez ce message par erreur, merci d'en avertir
> >> immédiatement l'expéditeur et de le détruire. L'intégrité du message ne
> >> pouvant être assurée sur Internet, la responsabilité de Worldline ne
> pourra
> >> être recherchée quant au contenu de ce message. Bien que les meilleurs
> >> efforts soient faits pour maintenir cette transmission exempte de tout
> >> virus, l'expéditeur ne donne aucune garantie à cet égard et sa
> >> responsabilité ne saurait être recherchée pour tout dommage résultant
> d'un
> >> virus transmis.
> >>
> >> This e-mail and the documents attached are confidential and intended
> >> solely for the addressee; it may also be privileged. If you receive this
> >> e-mail in error, please notify the sender immediately and destroy it.
> As its
> >> integrity cannot be secured on the Internet, the Worldline liability
> cannot
> >> be triggered for the message content. Although the sender endeavours to
> >> maintain a computer virus-free network, the sender does not warrant that
> >> this transmission is virus-free and will not be liable for any damages
> >> resulting from any virus transmitted.
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
> >
> >
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141121/d0850176/attachment.htm>