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 t
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.
>
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
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 autovac
Strange!!! Why does the index not works?
All my querys doesn't work with range dates I don't know what to do...
Please, help!
Bruno
-Mensagem original-
De: Decibel! [mailto:[EMAIL PROTECTED]
Enviada em: domingo, 29 de julho de 2007 13:36
Para: Ragnar
Cc: Bruno Rodrigues Siqu
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_encer
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=
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
tgres Versions -
#add_missing_from = off
#backslash_quote = safe_encoding# on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = off
#regex_flavor = advanced# advanced, extended, or basic
#sql_inheritance = on
# - Other Platforms & Clients -
#tra
: [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:
WHE
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
-
slash_quote = safe_encoding# on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = off
#regex_flavor = advanced# advanced, extended, or basic
#sql_inheritance = on
# - Other Platforms & Clients -
#transform_null_equals = off
#--
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
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 res
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
15 matches
Mail list logo
