<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-2">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=968472610-08032005><FONT face=Arial
color=#0000ff size=2>:-) mate pravdu nejak mi v rychlosti nedoslo, co je mysleno
funkci MIN() - jsem zvykly psat vestavene funkce velkymi pismeny...
:-(</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=968472610-08032005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=968472610-08032005><FONT face=Arial
color=#0000ff size=2>Ono to nikdy u SQL neni uplne jednoduche - zalezi jak ty
indexy indexy jsou udelane a v jakem jsou stavu. Provadite update statistik? A
take jak je zkonfigurovany SQL...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=968472610-08032005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=968472610-08032005><FONT face=Arial
color=#0000ff size=2>RadekCX</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=cs dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> hw-list-bounces@list.hw.cz
[mailto:hw-list-bounces@list.hw.cz] <B>On Behalf Of </B>Pavel
Novotný<BR><B>Sent:</B> Tuesday, March 08, 2005 11:14 AM<BR><B>To:</B>
'HW-news'<BR><B>Subject:</B> RE: Castecne OT postgresql +
rychlost<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=859241210-08032005><FONT face=Arial
color=#0000ff size=2>Pokud to tak je tak to je fakt genialni, neumim si
predstavit lepsi funkci pro vyuziti indexu nez min :-).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=859241210-08032005></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=cs dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> hw-list-bounces@list.hw.cz
[mailto:hw-list-bounces@list.hw.cz] <B>On Behalf Of </B>Radek
Vicek<BR><B>Sent:</B> Tuesday, March 08, 2005 10:30 AM<BR><B>To:</B>
'HW-news'<BR><B>Subject:</B> RE: Castecne OT postgresql +
rychlost<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=718312809-08032005><FONT face=Arial
color=#0000ff size=2>problem bude asi v te funkci min() - v tomhle pripade asi
SQL index nepouzije</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=718312809-08032005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=718312809-08032005><FONT face=Arial
color=#0000ff size=2>RadekCX</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=cs dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> hw-list-bounces@list.hw.cz
[mailto:hw-list-bounces@list.hw.cz] <B>On Behalf Of </B>Pavel
Novotný<BR><B>Sent:</B> Tuesday, March 08, 2005 10:21 AM<BR><B>To:</B>
hw-list@hw.cz<BR><B>Subject:</B> Castecne OT postgresql +
rychlost<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Tak jseme pred
rokem pustili sledovani provozniho stavu jisteho zarizeni, data se sbiraji a
ukladaji do Postgresql database 7.4.5 bezici na Linuxu. Pouzite PC neni
zadny high tech, ale bezne PC odpovidajici svymi parametry dobe
porizeni.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Do databaze se
uklada cas mereni a 4 namerene hodnoty, k dnesnimu dni ma databaze cca 6
milionu radku a nemela by se jiz vice zvetsovat, protoze starsi zaznamy by
se mely zacit agregovat.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Nejak se mi vsak
nezda rychlost prace s databazi, mam ji zindexovane podle casu a
presto napriklad SELECT min(time) ... trva tak
20-30s.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Delam neco blbe,
je treba postgresu zvlast rici, ze ma pracovat s indexy nebo to je u
takovych drobecku normalni ?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Velikost
adresare s databazi je cca 1.2G .</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=171020409-08032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=171020409-08032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=171020409-08032005>Dekuji za
nakopnuti</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=171020409-08032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=171020409-08032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=171020409-08032005></SPAN></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>