Seite 2 von 2 ErsteErste 12
Ergebnis 11 bis 12 von 12

Thema: Suche Alternative zu xact_start in pg_stat_activity

  1. #11
    akretschmer ist offline Super-Moderator
    Registriert seit
    29.10.2006
    Ort
    Nähe Dresden
    Beiträge
    5.337

    Standard

    Zitat Zitat von symbiont Beitrag anzeigen
    das ziel ist maximale performance .. da halte ich das seeeehhr wahrscheinlich
    Code:
    create table tstest(
      tstest timestamp without time zone default now()
    );
     
    insert into tstest values
    (DEFAULT), (DEFAULT), (DEFAULT), (DEFAULT), (DEFAULT), (DEFAULT),
    now() gibt immer die Startzeit der aktuellen TX. Wenn Du innerhalb einer TX die exakte Zeit brauchst, gibt es was anderes.

    Code:
    test=*# select now();
                  now
    -------------------------------
     2009-11-24 07:21:38.214483+01
    (1 row)
     
    test=*# select timeofday();
                  timeofday
    -------------------------------------
     Tue Nov 24 07:21:42.036023 2009 CET
    (1 row)
     
    test=*# select now();
                  now
    -------------------------------
     2009-11-24 07:21:38.214483+01
    (1 row)
    Andreas
    Geändert von Xandrian (24.11.2009 um 09:51 Uhr)
    --
    ads Das hatte dir akretschmer gestern schon gesagt und siehe da sobald du das machst, funktioniert es ;-)
    https://www.xing.com/profile/Andreas_Kretschmer7

  2. #12
    symbiont ist offline Erfahrener Benutzer
    Registriert seit
    17.03.2008
    Ort
    NULL
    Beiträge
    1.320

    Standard

    Zitat Zitat von castorp Beitrag anzeigen
    Bei einer Auflösung bis auf Mikrosekunden im timestamp Datentyp? Halte ich für seeehr unwahrscheinlich.
    nochmal wegen den micosekunden .. ob und wie (genauigkeit) die ueberhaupt gespeichert werden ist offenbar von einstellungen abhaengig ..

    Note: When timestamp values are stored as double precision floating-point numbers (currently the default), the effective limit of precision may be less than 6. timestamp values are stored as seconds before or after midnight 2000-01-01. Microsecond precision is achieved for dates within a few years of 2000-01-01, but the precision degrades for dates further away. When timestamp values are stored as eight-byte integers (a compile-time option), microsecond precision is available over the full range of values. However eight-byte integer timestamps have a more limited range of dates than shown above: from 4713 BC up to 294276 AD. The same compile-time option also determines whether time and interval values are stored as floating-point or eight-byte integers. In the floating-point case, large interval values degrade in precision as the size of the interval increases.
    wenn du timeofday() (nach wie ak meint verwendest) scheinen die ohnehin nicht gespeichert zu werden

    also auf die präzission der microsekunden zu vertrauen scheint ne schlechte idee

    det gleiche nur mit timeofday() auf meiner default installation ..

    Code:
    select to_char(tstest, 'HHMISS.SS.MS.US') from tstest;
    
    "082046.46.004.004000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    "082046.46.035.035000"
    Geändert von symbiont (24.11.2009 um 10:09 Uhr)

Seite 2 von 2 ErsteErste 12

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •  

Links: Tobias Bauer - IT- und Funkdienstleistungen   -   Bilderrahmen-kaufen.de - Der Onlineshop für Bilderrahmen & Fotorahmen   -   Funkforum