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
de in C. Is that true?
Regards,
--
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
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
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
クルズ クリスチアン ダニエル
<> 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
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)
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
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
-
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=
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
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
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
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
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
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
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)--
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
18 matches
Mail list logo