[Postgres] Quel est le nombre de tuples stockes par page?

Quel est le nombre de tuples stockes par page? [Postgres] - SQL/NoSQL - Programmation

Marsh Posté le 09-05-2003 à 12:42:43    

si vous pouviez m'aider, ce serait ultra-cooooooool!!!!!!!!!!!!

Reply

Marsh Posté le 09-05-2003 à 12:42:43   

Reply

Marsh Posté le 09-05-2003 à 13:04:24    

Si tu pouvais un peu expliquer ta question, ça serait cool.
 
Peut-être un début de piste :
 


4.6) How much database disk space is required to store data from a typical text file?
A PostgreSQL database may require up to five times the disk space to store data from a text file.
 
As an example, consider a file of 100,000 lines with an integer and text description on each line. Suppose the text string avergages twenty bytes in length. The flat file would be 2.8 MB. The size of the PostgreSQL database file containing this data can be estimated as 6.4 MB:
 
    36 bytes: each row header (approximate)
    24 bytes: one int field and one text field
   + 4 bytes: pointer on page to tuple
   ----------------------------------------
    64 bytes per row
 
   The data page size in PostgreSQL is 8192 bytes (8 KB), so:
 
   8192 bytes per page
   -------------------   =  128 rows per database page (rounded down)
     64 bytes per row
 
   100000 data rows
   --------------------  =  782 database pages (rounded up)
      128 rows per page
 
782 database pages * 8192 bytes per page  =  6,406,144 bytes (6.4 MB)
 
Indexes do not require as much overhead, but do contain the data that is being indexed, so they can be large also.
 
NULLs are stored in bitmaps, so they use very little space.


http://jamesthornton.com/postgres/FAQ/faq-english.html
 
Mais on sait même pas si tu parle de page mémoire ou disque...
En tout ça, c'est dépendant du paramètrage de la base dans tous les cas normalement.

Reply

Marsh Posté le 09-05-2003 à 13:05:20    

Reply

Marsh Posté le 09-05-2003 à 19:40:29    

je parle de pages memoire

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed