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 > On 04/24/2013 11:20 AM, Daniel Cristian Cruz wrote: > >> I've done an expl

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

5:4... > > > > > > > > -- > > View this message in context: > http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-TIMESTAMP-arg1-arg1-tp5761389p5761390.html > > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > > > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@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

value || 'k ON ' || table_name ||' USING btree (foo_id, foo_num)'; >> EXECUTE 'GRANT ALL ON TABLE ' || table_name || ' TO foorole, postgres'; >> EXECUTE 'GRANT SELECT ON TABLE ' || table_name || ' TO blarole'; >> >> END IF; >> >> EXECUTE 'INSERT INTO ' || table_name ||' VALUES (($1).*)' USING NEW ; >> >> RETURN NULL; >> END; >> $$ >> LANGUAGE plpgsql; >> >> >> but it doesn't seem to work. It doesn't actually create new partition >> tables. >> The entries are inserted into "foo" >> >> I attach a test .sql file that contains the data of the table >> >> >> any help would save me from a lot of time! >> >> thank you in advance! >> >> dafni >> > > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[GENERAL] Debian Weezy PGDG CD/DVD iso image

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

;), how can I report a issue in pg_upgrade? Thanks, Adrian, Tomas and Tom. 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 &g

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

2013/4/22 Daniel Cristian Cruz > 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, > ( SELE

Re: [GENERAL] Memory usage after upgrade to 9.2.4

ante.id_matricula LEFT JOIN justificativas ON justificativas.id_matricula = presenca.id_matricula AND justificativas.id_diario = presenca.id_diario AND justificativas.id_aula = presenca.id_aula AND justificativas.id_evento = presenca.id_evento WHERE matricula_cancelamento.id_matricula IS NULL AND estudante.id_matricula = 147124 GROUP BY estudante.id_matricula, estudante.id_diario ) AS contagem; server 9.1: http://explain.depesz.com/s/jD4 server 9.2: http://explain.depesz.com/s/hV9 100MB more in RES memory after this one. Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

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 Date: 2013/4/20 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Adrian Klaver 2013/4/20 Adrian Klaver > On 04/20/2013 04:30 PM, Daniel Cristian Cruz wr

Fwd: [GENERAL] Memory usage after upgrade to 9.2.4

Sorry, I answered to Tomas only... -- Forwarded message -- From: Daniel Cristian Cruz Date: 2013/4/21 Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4 To: Tomas Vondra I had the same environment, almost: 2013/4/21 Tomas Vondra > > 2) What are the hardware

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

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

Re: [GENERAL] Memory usage after upgrade to 9.2.4

15 0 6684m 228m 85m S 0.0 0.2 0:00.59 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/20 Adrian Klaver > 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

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 >

[GENERAL] Memory usage after upgrade to 9.2.4

I'm stuck 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] Bad plan on a huge table query

give a bad > estimate, other than bad statistics. There are no filters so cross-column > correlations can't be throwing it off, so why is it so bad? > > Also, it would be nice to see: > > select * from pg_stats where tablename = 'idx_aula_confirmacao_2' \x\g\x > > (which I assume is a function-based index) > > Cheers, > > Jeff > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

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

.id_produto_educacao, 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 Cristia

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

2013/3/21 Alban Hertroys > On Mar 20, 2013, at 22:36, Daniel Cristian Cruz > 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

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 > 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. > &g

[GENERAL] Bad plan on a huge table query

eSQL 9.2.3, 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 > Hi, > > I

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

eSQL 9.2.3, 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] Is there a way to add a detail message in a warning with pl/Python?

ample.html#NormalizedErrorsMostFrequentReport I read 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

[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 r