Re: lug-bg: PostgreSQL (MySQL) vs MSSQL

[emilio@xxxxxxxxxxx (Emil Slavov)]

                  Preminavaneto ot MSSQL kam niakakva druga baza vinagi 
triabva da stava sas prerabotka na indexiraneto a ne da se portva 
direktno. Smisala na indexite v MSSQL e dosta po razlichen. Probvai da 
izpalnish postgres sas -s -t ili pak sas -A za da vidish dali problema 
e v bazata ili e sistemen.

> Bozhidar Roydev wrote:
> > Zdrawejte kolegi,
> > Moi priqteli sa stignali do reshenieto da zamenqt MicroSoft SQL pod 
NT s 
> > Linux baziran SQL server. Sega sa w sferata na experimentite i 
iskam da wi 
> > pomolq za sydejstwie!
> > Otnachalo zapochnaha s MySQL, no sega sa prehwyrlili wsichko pod 
> > PostgreSQL. Ponezhe ne sym se zanimawal s SQL-i shte predostawq 
> > specializiranite wyprosi i otgowori na samite tqh. Predpolagam 
weche sa se 
> > zapisali w grupata.
> >   Eto i nakratko configuraciqta i problema kakto sa mi gi izpratili:
> >                  configuraciq:
> >          Celeron 600 MHz
> >          Ram 128 MB
> >          Hdd 20 Gb
> >          OS RedHat 7.2
> >                  Problem:
> > Pri prosta zajawka ot 100 000 zapisa wremeto e 4sec
> > - natowarwane CPU 99%
> > Pri slojna zajawka - ot mnogo tablici i s uslowija
> > wremeto e 1 - 5 min w zawisimost ot zajawkata i
> > natowarwane na CPU 99 % za proces. Wsjaka zajawka si
> > owtarja proces. Pametta se zaema ne powece ot 3.5 % a
> > swap- a e prazen
> > Obsto wzeto w towa e problema - Za srawnenie systite
> > zajwki na MS SQL sa za okolo 1 sec.
> > 
> > Wyprosyt e dali e wyzmozhno optimizirane i kakwo mozhe da se 
ochakwa kato 
> > max. byrzodejstwie?
> 
> Imash li podhodiashti indexi? Ako imash sled kato si gi definiral
> startira li vacuum analyze?
> 
> -- 
> Georgi Chorbadzhiyski
> http://georgi.unixsol.org/
> 
> 
========================================================================
====
> A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
> http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara 
Zagora
> To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
> 
========================================================================
====
> 
> 
> 
> 
> 
> 

--------- 
Best Regards:

Emil Slavov
Network Engineer at GlobalCom Ltd.
Web: http://emilio.globcom.net
E-mail: emilio@xxxxxxxxxxx
Phone: +359 87 323553
============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================