From: | Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com> |
---|---|
To: | "Ing(dot) Marcos Ortiz Valmaseda" <mlortiz(at)uci(dot)cu> |
Cc: | Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Subject: | Re: como usar pgbench |
Date: | 2011-01-26 22:27:49 |
Message-ID: | AANLkTi=MCgxJYgN=JBwarOotonXcpmEwJt4ey2RysSj9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
saludos marcos
fijate que saque la version y tengo la 9.0.1, estoy haciendo pruebas en mi
maquina
y me sigue marcando el error
ERROR: column "buffers_backend_fsync" does not exist
LINE 1: SELECT buffers_backend_fsync FROM pg_stat_bgwriter
feria=# select version();
version
------------------------------------------------------------------------------------------------------------
PostgreSQL 9.0.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-46), 32-bit
e hice una consulta de la tabla pg_stat_bgwriter y mira lo que me arroja
feria=# SELECT * FROM pg_stat_bgwriter;
checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean |
maxwritten_clean | buffers_backend | buffers_alloc
-------------------+-----------------+--------------------+---------------+------------------+-----------------+---------------
5672 | 134 | 587710 | 208484
| 248 | 12841079 | 1516144
(1 row)
que puedo hacer??
2011/1/26 Ing. Marcos Ortiz Valmaseda <mlortiz(at)uci(dot)cu>
> ¿qué versión de PostgreSQL estás usando?
> En versiones anteriores a la 9.0 esa columna no existe. Ejemplo:
>
> djangodb=# SELECT * FROM pg_stat_bgwriter;
> checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean |
> maxwritten_clean | buffers_backend | buffers_alloc
>
> -------------------+-----------------+--------------------+---------------+------------------+-----------------+---------------
> 368 | 4 | 15 | 0 |
> 0 | 0 | 1551
> (1 row)
>
> djangodb=# select version();
> version
>
> ---------------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.4.6 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit
> (1 row)
>
> djangodb=#
>
> Saludos
> --
> Ing. Marcos Luís Ortíz Valmaseda
> System Engineer -- Database Administrator
>
> Centro de Tecnologías de Gestión de Datos (DATEC)
> Universidad de las Ciencias Informáticas
> http://postgresql.uci.cu
>
>
--
ISC Miguel Angel Hernandez Moreno
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2011-01-26 22:37:03 | Re: como usar pgbench |
Previous Message | Miguel Angel Hernandez Moreno | 2011-01-26 21:47:38 | Re: como usar pgbench |