Re: [PERFORM] Index on a range array

2013-08-14 Thread Daniel Cristian Cruz
I guess this is not a performance question... What kind of question would it be? Admin, General or SQL? 2013/8/13 Daniel Cristian Cruz > Hello, > > I'm trying to simplify a schema, where I had many ranges floating around. > My idea is to put them all in an array field an

[PERFORM] Index on a range array

2013-08-13 Thread Daniel Cristian Cruz
de in C. Is that true? Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [PERFORM] Common slow query reasons - help with a special log

2011-12-10 Thread Daniel Cristian Cruz
2011/12/10 Tomas Vondra > On 10.12.2011 23:40, Daniel Cristian Cruz wrote: > > At work we have a 24 cores server, with a load average around 2.5. > > A single query is processes by a single CPU, so even if the system is > not busy a single query may hit CPU bottleneck. The

Re: [PERFORM] Common slow query reasons - help with a special log

2011-12-10 Thread Daniel Cristian Cruz
e you already have performance > issues. > > Tomas > > On 10.12.2011 17:52, Daniel Cristian Cruz wrote: > > Hi all, > > > > I'm trying to figure out some common slow queries running on the server, > > by analyzing the slow queries log. > > > > I found

[PERFORM] Common slow query reasons - help with a special log

2011-12-10 Thread Daniel Cristian Cruz
te a paper that needs this information for my postgraduate course. The focus of my work will be the log data, not PostgreSQL itself. If I succeed, maybe it can be a tool to help all of us. Thank you, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[PERFORM] Fwd: Not so simple query and a half million loop

2008-12-02 Thread Daniel Cristian Cruz
<> 0), 0) ~ 1 second I've tryied to increase statistics to maximum, with no success. This is the eGroupware database schema, with a few records. The complete queries and plan folows. -- Forwarded message -- From: Daniel Cristian Cruz <[EMAIL PROTECTED]> Date: 20

Re: [PERFORM] PostgreSQL NOT IN performance

2008-11-19 Thread DANIEL CRISTIAN CRUZ
T INs when list of values to remove is long >takes very much time. >So the question is: I am willing to participate in postgresql development >because it may be easier to fix planner then to rewrite all my queries :). >How can I? (I mean to work on query planner enhancements by providing new >options of query rewrite, not to work on other thing nor on enhancing >planner in other ways, like better estimations of known plans). > > > >   -- Daniel Cristian Cruz Administrador de Banco de Dados Direção Regional - Núcleo de Tecnologia da Informação SENAI - SC Telefone: 48-3239-1422 (ramal 1422)

Re: [PERFORM] select on 22 GB table causes "An I/O error occured while sending to the backend." exception

2008-08-27 Thread DANIEL CRISTIAN CRUZ
Maybe strace could help you find the problem, but could cause a great overhead... "Bill Moran" <[EMAIL PROTECTED]> escreveu: > ... -- Daniel Cristian Cruz Administrador de Banco de Dados Direção Regional - Núcleo de Tecnologia da Informação SENAI - SC Telefone: 48-32

Re: [PERFORM] Many to many join seems slow?

2007-05-15 Thread Daniel Cristian Cruz
QUERY PLAN - Merge Join (cost=524224.49..732216.29 rows=92447 width=97) This way you get all word matches for the French language. Shouldn't it be all matches for a specific word (s.value = 'word' in WHERE)? -- Daniel Cristian Cruz -

Re: [PERFORM] Nested loops overpriced

2007-05-09 Thread Daniel Cristian Cruz
2007/5/9, Gregory Stark <[EMAIL PROTECTED]>: "Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > -> Nested Loop (cost=0.00..13187.94 rows=93 width=4) (actual time=2.622..125.739 rows=50 loops=1) > -> Seq Scan on u (cost=0.00..2838.80 rows=

Re: [PERFORM] Nested loops overpriced

2007-05-09 Thread Daniel Cristian Cruz
dly unusual data). Apparently, however, the caching effects are much more significant than the model takes into account. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 7: You can help

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
2007/3/28, Tom Lane <[EMAIL PROTECTED]>: "Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > 2007/3/28, chris smith <[EMAIL PROTECTED]>: >>> Total runtime: 13.844 ms >> >> Why bother? > Because faster could be better in a very busy

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
2007/3/28, chris smith <[EMAIL PROTECTED]>: > Total runtime: 13.844 ms Why bother? Because faster could be better in a very busy system. -- Daniel Cristian Cruz Analista de Sistemas

[PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
Its an old PostgreSQL server: SELECT version(); version -- PostgreSQL 7.4.13 on x86_64-redhat-linux-gnu, compiled by GCC x86_64-redhat-linux-gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-2) -- Daniel Cristian Cruz Analista de Sistemas

Re: [PERFORM] Strange left outer join performance issue

2007-03-23 Thread Daniel Cristian Cruz
ords cr (cost=0.00..3639.55 rows=915 width=363) (actual time=2.133..7.649 rows=3 loops=388) Index Cond: (cr.buyer_alias_id = "outer".id) Total runtime: 3117.713 ms (7 rows) -- Daniel Cristian Cruz Analista de Sistemas

Re: [PERFORM] Determine dead tuples size

2007-03-15 Thread Daniel Cristian Cruz
Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Daniel Cristian Cruz Analista de Sistemas ---(end of broadcast)--- TIP 6: explain anal

Re: [PERFORM] Recreate big table

2007-02-09 Thread Daniel Cristian Cruz
ce, Akos Gabriel ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Daniel Cristian Cruz Analista de Sistemas Especialista postgreSQL e Linux Instrutor Certificado Mandriva ---(end of broadcast)--

Re: [PERFORM] Large table performance

2007-01-13 Thread Daniel Cristian Cruz
he shared buffer cache.) /* Steinar */ -- Homepage: http://www.sesse.net/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate -- Daniel Cristian Cruz Anali