From: | Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com> |
---|---|
To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
Cc: | Lista PostgreSql <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: velocidad en postgres |
Date: | 2010-07-09 20:27:20 |
Message-ID: | AANLkTimsFsGI8jpVORcj3j05cRmrjd6fZXDgj0rXtC5S@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
envio el resultado de mi vaccum
INFO: vacuuming "monterrey.boleturavl_2010_07_09"INFO: scanned index
"unicos2_boleturavl_2010_07_09" to remove 1102 row versions
DETAIL: CPU 0.16s/0.61u sec elapsed 5.22 sec.INFO: scanned index
"idx_hreal_eco_bol2_boleturavl_2010_07_09" to remove 1102 row versions
DETAIL: CPU 0.07s/0.62u sec elapsed 71.66 sec.INFO:
"boleturavl_2010_07_09": removed 1102 row versions in 263 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: index "unicos2_boleturavl_2010_07_09" now contains 5247076 row
versions in 57699 pages
DETAIL: 10 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: index "idx_hreal_eco_bol2_boleturavl_2010_07_09" now contains 5256444
row versions in 26373 pages
DETAIL: 10 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
y el free de mi sistema operativo
total used free shared
buffers cached
Mem: 32811112 30305240 2505872 0 219496
28079640
-/+ buffers/cache: 2006104 30805008
Swap: 16771852 0 16771852
gracias por su ayuda!!
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2010-07-09 20:38:42 | Re: velocidad en postgres |
Previous Message | Miguel Angel Hernandez Moreno | 2010-07-09 20:24:30 | Re: velocidad en postgres |