I'll consult partition with my db team. Thanks for suggestion. 2014-11-19 16:50 GMT+01:00 Paul Robert Marino <[email protected]>:
> 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 > <[email protected]> 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 > > <[email protected]>: > >> > >> Hello > >> > >> > >> > >> I’m very interesting about your migration. Could you please give your > >> feedback when your database migration will be done ? > >> > >> > >> > >> Thanks > >> > >> > >> > >> De : [email protected] > >> [mailto:[email protected]] De la part de Krzysztof > Pawlowski > >> Envoyé : mercredi 19 novembre 2014 15:41 > >> À : [email protected] > >> 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 < > [email protected]>: > >> > >> 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: [email protected] > >> 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 > >> <[email protected]> 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 < > [email protected]>: > >> > >> Hello Krzysztof, good morning > >> > >> > >> > >> you can use Oracle as backend > >> (https://fedorahosted.org/spacewalk/wiki/HowToInstall#Databaseserver) > >> > >> > >> > >> B'Regards > >> > >> > >> > >> > >> ______________ > >> Atenciosamente > >> Waldirio > >> msn: [email protected] > >> 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 > >> <[email protected]> wrote: > >> > >> Is there any way to switch db backend to oracle ? > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > >> > >> > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > >> > >> > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > >> > >> > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] > >> 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 > >> [email protected] > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > > > > > > > _______________________________________________ > > Spacewalk-list mailing list > > [email protected] > > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
