pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: David Griffiths <dgriffiths@boats.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning/performance issue....
Date: Wed, 01 Oct 2003 12:35:30 +0530
Message-ID: <3F7A7CBA.4060507@persistent.co.in> (raw)
In-Reply-To: <058d01c38791$0d0a91b0$6501a8c0@griffiths2>
References: <058d01c38791$0d0a91b0$6501a8c0@griffiths2>

David Griffiths wrote:

> And finally,
>  
> Here's the contents of the postgresql.conf file (I've been playing with 
> these setting the last couple of days, and using the guide @ 
> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html to 
> make sure I didn't have it mis-tuned):
>  
> tcpip_socket = true
> max_connections = 500        # We will need quite a few connections; 
> currently only one connection to database, however
> port = 5432
> shared_buffers = 5000           # I've tried 5000 to 80,000 with no 
> apparent difference
> wal_buffers = 16
> sort_mem = 256                    # decreased this due to the large # of 
> connectiosn
> effective_cache_size = 50000 # read that this can improve performance; 
> hasn't done anything.

Reading this whole thread, I think most of the improvement you would get would 
be from rethinking your schema from PG point of view and examine each query.

After you changed your last query as Tom suggested for explicit join, how much 
improvement did it make? I noticed that you put 
'commercial_entity.commercial_entity_id=225528' as a second codition. Does it 
make any difference to put it ahead in where clause list?

  HTH

  Shridhar




view thread (16+ messages)  latest in thread

Message-ID: <3F7A7CBA.4060507@persistent.co.in>
Permalink:  ../3F7A7CBA.4060507@persistent.co.in/
Also on:    postgresql.org/message-id/3F7A7CBA.4060507@persistent.co.in

 · 

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_daithankar@persistent.co.in, dgriffiths@boats.com
  Subject: Re: Tuning/performance issue....
  In-Reply-To: <3F7A7CBA.4060507@persistent.co.in>

* 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