Re: [GENERAL] Memory usage after upgrade to 9.2.4

I found where the problem is: http://www.postgresql.org/docs/9.1/static/release-9-1-6.html It could be nice if something is added to the 9.2 release notes to warn the admins. 2013/4/24 Adrian Klaver adrian.kla...@gmail.com On 04/24/2013 11:20 AM, Daniel Cristian Cruz wrote: I've done

Re: [GENERAL] Migration from DB2 to PostgreSQL-TIMESTAMP(arg1,arg1)

...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] dynamic partitioning

of time! thank you in advance! dafni -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[GENERAL] Debian Weezy PGDG CD/DVD iso image

like to share it? Didn't found anything on google. Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] Memory usage after upgrade to 9.2.4

. It's a specific issue, it's on backup until May, 1st. Until there, if someone would like to know something about it, just ask me, I would like to help removing an issue. 2013/4/23 Daniel Cristian Cruz danielcrist...@gmail.com 2013/4/23 Adrian Klaver adrian.kla...@gmail.com On 04/23/2013 04

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/22 Daniel Cristian Cruz danielcrist...@gmail.com query1: EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino, ced.evento, ced.id_eventos IS NOT NULL AS aula_dividida, ac.titulo, ced.id_tipo_evento, ced.tipo_evento, ac.media_referencia, p.nome, ef.nome AS nomeEspacoFisico

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/23 Adrian Klaver adrian.kla...@gmail.com On 04/23/2013 04:23 AM, Daniel Cristian Cruz wrote: 2013/4/22 Daniel Cristian Cruz danielcrist...@gmail.com mailto:danielcristian@gmail.**com danielcrist...@gmail.com query1: EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio

Re: [GENERAL] Memory usage after upgrade to 9.2.4

/2013 09:29 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.klaver@gmail.**com adrian.kla...@gmail.com 1) Major upgrade from 9.1.4 to 9.2.4. Used pg_upgrade Tested on VM with 9.2.4 and no problems. Same machine used

Re: [GENERAL] Memory usage after upgrade to 9.2.4

postgres: sgn2 senai 10.1.3.1(59466) idle 30503 pg91 15 0 6682m 212m 71m S 0.0 0.2 0:00.43 postgres: sgn2 senai 10.1.3.1(48499) idle -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/21 Adrian Klaver adrian.kla...@gmail.com On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us Tomas Vondra t...@fuzzy.cz mailto:t...@fuzzy.cz writes: I do have a log with the memory context info printed after

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/21 Adrian Klaver adrian.kla...@gmail.com On 04/21/2013 07:50 AM, Daniel Cristian Cruz wrote: 2013/4/21 Adrian Klaver adrian.kla...@gmail.com mailto:adrian.klaver@gmail.**com adrian.kla...@gmail.com On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote: 2013/4/21 Tom

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

Sorry, I answered to Tomas only... -- Forwarded message -- From: Daniel Cristian Cruz danielcrist...@gmail.com Date: 2013/4/21 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Tomas Vondra t...@fuzzy.cz I had the same environment, almost: 2013/4/21 Tomas Vondra t

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

And this one only to Adrian. Sorry to all. -- Forwarded message -- From: Daniel Cristian Cruz danielcrist...@gmail.com Date: 2013/4/20 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Adrian Klaver adrian.kla...@gmail.com 2013/4/20 Adrian Klaver adrian.kla

[GENERAL] Memory usage after upgrade to 9.2.4

with all the same parameters from 9.1.4. The only solution right now is to rollback to the older version. Does someone got something like this before? Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] Memory usage after upgrade to 9.2.4

I think I didn't make it clear: the session memory usage is growing up too fast, until all server memory got used and swap occurs. Never saw something like that. The version is under a test enviroment for a long time... Thanks if someone could help me. 2013/4/20 Daniel Cristian Cruz

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/20 Adrian Klaver adrian.kla...@gmail.com On 04/20/2013 04:08 PM, Daniel Cristian Cruz wrote: I think I didn't make it clear: the session memory usage is growing up too fast, until all server memory got used and swap occurs. Never saw something like that. The version is under a test

Re: [GENERAL] Bad plan on a huge table query

, Daniel Cristian Cruz danielcrist...@gmail.com wrote: Are you using autovacuum? If so, you probably need to tune it more aggressively. For the short term, running an ANALYSE on those tables should at least get you more accurate query plans. I've done it; with default_statistics_target

Re: [GENERAL] Bad plan on a huge table query

, default_statistics_target on 1000. I can't remember what to make PostgreSQL sees a better estimate in the scan of aula_confirmacao and the join with presenca. I got rusty after a long time just doing modeling. Does someone has some idea on that? Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] Bad plan on a huge table query

I've reduced default_statistics_target to 200, and saw less nested loops. I'm trying some changes to the query, but no better results. The table presenca has 26 million rows. The table aula_confirmacao has 840 thousand rows. 2013/3/21 Daniel Cristian Cruz danielcrist...@gmail.com Hi, I'm

[GENERAL] Bad plan on a huge table query

, default_statistics_target on 1000. I can't remember what to make PostgreSQL sees a better estimate in the scan of aula_confirmacao and the join with presenca. I got rusty after a long time just doing modeling. Does someone has some idea on that? Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [GENERAL] Bad plan on a huge table query

And now, it runs, at least: http://explain.depesz.com/s/GDJn No one could send a guess on it? 2013/3/21 Daniel Cristian Cruz danielcrist...@gmail.com I've reduced default_statistics_target to 200, and saw less nested loops. I'm trying some changes to the query, but no better results

Re: [GENERAL] Bad plan on a huge table query

2013/3/21 Alban Hertroys haram...@gmail.com On Mar 20, 2013, at 22:36, Daniel Cristian Cruz danielcrist...@gmail.com wrote: Hi, I'm trying to figure out why does the planner found 1 row estimate using nested loops over a big table. There is no return from it: http://explain.depesz.com/s

Re: [GENERAL] Bad plan on a huge table query

, aluno_mensal.produto_educacao, aluno_mensal.unidade, aluno_mensal.unidade_execucao, aluno_mensal.modalidade, aluno_mensal.id_pessoa, aluno_mensal.nome_pessoa, presenca.id_diario, aula_confirmacao.inicio::date, presenca.justificativa_falta, mensal.ano, mensal.mes; 2013/3/21 Daniel Cristian Cruz danielcrist

Re: [GENERAL] Is there a way to add a detail message in a warning with pl/Python?

the code yesterday, and didn't find how to get a detail through it. Maybe my C knowledge is somewhat broken... -- Daniel Cristian Cruz Unidade de Tecnologia da Informação Sistema FIESC Rod. Admar Gonzaga, 2765 - Itacorubi - 88034-001 - Florianópolis - SC Fone (48) 3239-1422 - e-mail: daniel.c

[GENERAL] Is there a way to add a detail message in a warning with pl/Python?

: plpy.warning('test', 'detail') - output both values plpy.warning({'message': 'test', 'detail': 'detail'}) - output the dict plpy.warning('test', detail='detail') - fail Am I missing something? I would read the code, but I had no time right now... Thanks, -- Daniel Cristian Cruz Unidade de