Re: [GENERAL] strange performance problem (SOLVED)

2009-03-01 Thread Linos
Linos escribió: Linos escribió: Linos escribió: Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria"

Re: [GENERAL] strange performance problem (SOLVED)

2009-03-01 Thread Linos
Linos escribió: Linos escribió: Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria" FROM "modelo_sub

Re: [GENERAL] strange performance problem

2009-02-28 Thread Linos
I have been testing with tcpdump but i dont see the problem in the traffic (aside from the fact that it gives big jumps in ms between packets of data, but i dont know why), i have tested on other debian machines with the same result, i have upgraded kernel to 2.6.28 and postgresql to 8.3.6 (e

Re: [GENERAL] strange performance problem

2009-02-28 Thread Linos
Linos escribió: Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria" FROM "modelo_subfamilia" PSQL wit

Re: [GENERAL] strange performance problem

2009-02-27 Thread Linos
Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria" FROM "modelo_subfamilia" PSQL with \timing: -develo

Re: [GENERAL] strange performance problem

2009-02-27 Thread Richard Huxton
Linos wrote: > Richard Huxton escribió: >> Linos wrote: >>> 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: >>> SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", >>> "id_seccion", "id_categoria" FROM "modelo_subfamilia" >> >>> PSQL with \timing: >>> -developm

Re: [GENERAL] strange performance problem

2009-02-27 Thread Linos
Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria" FROM "modelo_subfamilia" PSQL with \timing: -development: Time: 72,441 ms -server: Time:

Re: [GENERAL] strange performance problem

2009-02-27 Thread Richard Huxton
Linos wrote: > 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: > SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", > "id_seccion", "id_categoria" FROM "modelo_subfamilia" > PSQL with \timing: > -development: Time: 72,441 ms > -server: Time: 78,762 ms > but

[GENERAL] strange performance problem

2009-02-27 Thread Linos
Hello i have the same table with the same data in my development machine and in a small server in production. The table is this: Tabla «modelo_subfamilia» Columna| Tipo | Modificadores ---+---+--- nombre| character var