Skip site navigation (1) Skip section navigation (2)

Re: como usar pgbench

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 (view raw or flat)
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

In response to

Responses

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2011-01-26 22:37:03
Subject: Re: como usar pgbench
Previous:From: Miguel Angel Hernandez MorenoDate: 2011-01-26 21:47:38
Subject: Re: como usar pgbench

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group