pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar@frodo.hserus.net>
To: Fabio Panizzutti <panizzutti@interlogica.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query plan on identical tables differs . Why ?
Date: Thu, 13 May 2004 18:35:19 +0530
Message-ID: <40A3728F.2030402@frodo.hserus.net> (raw)
In-Reply-To: <005c01c438e7$ced25c30$3c02020a@ufficio>
References: <005c01c438e7$ced25c30$3c02020a@ufficio>

Fabio Panizzutti wrote:
> storico=# explain select tag_id,valore_tag,data_tag from storico_misure
> where (data_tag>'2004-05-03' and data_tag <'2004-05-12') and
> tag_id=37423 ;

Can you please post explain analyze? That includes actual timings.

Looking at the schema, can you try "and tag_id=37423::integer" instead?

> enable_hashagg = false
> enable_hashjoin = false
> enable_indexscan = true
> enable_mergejoin = true
> enable_nestloop = false
> enable_seqscan = true
> enable_sort = false
> enable_tidscan = false

Why do you have these off? AFAIK, 7.4 improved hash aggregates a lot. So you 
might miss on these in this case.

> # - Planner Cost Constants -
> 
> #effective_cache_size = 1000	# typically 8KB each

You might set it to something realistic.

And what is your hardware setup? Disks/CPU/RAM?

Just to be sure, you went thr.
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html and 
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html?

HTH

  Regards
    Shridhar



view thread (2+ messages)

Message-ID: <40A3728F.2030402@frodo.hserus.net>
Permalink:  ../40A3728F.2030402@frodo.hserus.net/
Also on:    postgresql.org/message-id/40A3728F.2030402@frodo.hserus.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: shridhar@frodo.hserus.net, panizzutti@interlogica.net
  Subject: Re: Query plan on identical tables differs . Why ?
  In-Reply-To: <40A3728F.2030402@frodo.hserus.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox