Scott Marlowe wrote:
random_page_cost = 1# units are one sequential page
fetch
Seldom if ever is it a good idea to bonk the planner on the head with
random_page_cost=1. setting it to 1.2 ot 1.4 is low enough, but 1.4
to 2.0 is more realistic.
Which is probably the
Please reply-all so others can learn and contribute.
On Sun, Jul 29, 2007 at 09:38:12PM -0700, Craig James wrote:
Decibel! wrote:
It's unlikely that it's going to be faster to index scan 2.3M rows than
to sequential scan them. Try setting enable_seqscan=false and see if it
is or not.
Out
On Sat, Jul 28, 2007 at 10:36:16PM +, Ragnar wrote:
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
where
to_char( data_encerramento ,'-mm')
between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try:
WHERE data_encerramento
original-
De: Decibel! [mailto:[EMAIL PROTECTED]
Enviada em: domingo, 29 de julho de 2007 13:36
Para: Ragnar
Cc: Bruno Rodrigues Siqueira; pgsql-performance@postgresql.org
Assunto: Re: RES: [PERFORM] select on 1milion register = 6s
On Sat, Jul 28, 2007 at 10:36:16PM +, Ragnar wrote:
On lau
Scott Marlowe wrote:
On 7/28/07, Bruno Rodrigues Siqueira [EMAIL PROTECTED] wrote:
stats_start_collector = off
#stats_command_string = off
#stats_block_level = off
#stats_row_level = off
#stats_reset_on_server_start = off
I think you need stats_row_level on for autovacuum, but I'm
On Sun, Jul 29, 2007 at 01:44:23PM -0300, Bruno Rodrigues Siqueira wrote:
EXPLAIN
ANALYZE
select
to_char(data_encerramento,'mm/') as opcoes_mes,
to_char(data_encerramento,'-mm') as ordem from detalhamento_bas
where
data_encerramento = '01/12/2006' and
Friends,
Who can help me? My SELECT in a base with 1 milion register,
using expression index = 6seconds.
Please, I don't know how to makes it better.
Thanks
Bruno Rodrigues Siqueira wrote:
Who can help me? My SELECT in a base with 1 milion register,
using expression index = 6seconds…
Run your query using
EXPLAIN ANALYZE SELECT ... your query ...
and then post the results to this newsgroup. Nobody can help until they see
the
Do you have analyzed your table before doing this ?
Le samedi 28 juillet 2007, Bruno Rodrigues Siqueira a écrit :
Friends,
Who can help me? My SELECT in a base with 1 milion register,
using expression index = 6seconds.
Please, I don't know how to makes it better.
-Mensagem original-
De: Craig James [mailto:[EMAIL PROTECTED]
Enviada em: sábado, 28 de julho de 2007 16:59
Para: Bruno Rodrigues Siqueira; pgsql-performance@postgresql.org
Assunto: Re: [PERFORM] select on 1milion register = 6s
Bruno Rodrigues Siqueira wrote:
Who can
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
where
to_char( data_encerramento ,'-mm')
between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try:
WHERE data_encerramento between '2006-12-01' and '2007-01-31'
gnari
: [PERFORM] select on 1milion register = 6s
On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote:
where
to_char( data_encerramento ,'-mm')
between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try:
WHERE data_encerramento between '2006-12-01
= '' # list of custom variable class
names
-Mensagem original-
De: Hervé Piedvache [mailto:[EMAIL PROTECTED]
Enviada em: sábado, 28 de julho de 2007 16:57
Para: pgsql-performance@postgresql.org
Cc: Bruno Rodrigues Siqueira
Assunto: Re: [PERFORM] select on 1milion register = 6s
Do you
Yes, i do.
-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Hervé Piedvache
Enviada em: sábado, 28 de julho de 2007 16:57
Para: pgsql-performance@postgresql.org
Cc: Bruno Rodrigues Siqueira
Assunto: Re: [PERFORM] select on 1milion register = 6s
Do you
On 7/28/07, Bruno Rodrigues Siqueira [EMAIL PROTECTED] wrote:
Ok.
QUERY PLAN
Sort (cost=11449.37..11449.40 rows=119 width=8) (actual
time=14431.537..14431.538 rows=2 loops=1)
Sort Key: to_char(data_encerramento, '-mm'::text)
- HashAggregate (cost=11448.79..11448.96 rows=119
15 matches
Mail list logo