vendredi 27 mars 2015

PgAdmin III - Number of lines returned during insertion


Not crucial question here, just curiosity.


I am inserting data via multiple scripts in a base running in PostgreSQL.


I wanted to test the time requested to end the insert, so I requested many times the number of lines in the table as follow :



SELECT COUNT(*) FROM "table";


I noticed that everytime the number of line is following a schema : last digits (hundreds, tens and units) are the same as the firsts (millions and thousands).


By example :



  • if there was around 39k lines, the number of lines returned was 39039,

  • if there was around 8518k lines, the number of lines returned was 8526518 (8518000 + 8518)


Any idea from where it come? Is it by default? or maybe a personal config?


More info :


Same behaviour on psql.


I am adding 1k inserts by connection to the base, so I don't think it's related.


When the inserts are over, the correct number of lines is returned.


I did enought requests to ensure that's not coincidence.


I am working on Windows.




PS : I haven't found already done post but I could have fail my search, sorry if it's the case.





Aucun commentaire:

Enregistrer un commentaire