pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Madison Kelly <linux@alteeve.com>
To: karim.nassar@acm.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Index ot being used
Date: Wed, 15 Jun 2005 13:33:20 -0400
Message-ID: <42B06660.1060504@alteeve.com> (raw)
In-Reply-To: <1118854322.7135.133.camel@localhost.localdomain>
References: <1825.216.209.137.1.1118419819.squirrel@mail.alteeve.com>
	<20050610155535.GO8451@tobias.nordicbet.com>
	<42AC42CB.8050703@alteeve.com>
	<24636.1118591783@sss.pgh.pa.us>
	<42ACBC95.9020404@alteeve.com>
	<20050613030001.GB17491@wolff.to>
	<20050613031317.GA18988@wolff.to>
	<42AD008D.4080600@alteeve.com>
	<20050613035346.GA20703@wolff.to>
	<42AD0B94.9090508@alteeve.com>
	<20050613132852.GA31142@wolff.to>
	<42ADC77B.7000007@alteeve.com>
	<22127.1118686403@sss.pgh.pa.us>
	<42ADD8DC.1000001@alteeve.com>
	<3643.1118696404@sss.pgh.pa.us>
	<42ADFAF8.7080107@alteeve.com>
	<1118854322.7135.133.camel@localhost.localdomain>

Karim Nassar wrote:
> Your goal is admirable. However, many people tweak their postgresql.conf
> files, and your program can't know whether or not this has happened. It
> might be a good idea to have a var $do_db_optimization, which defaults
> to on. Then, if your users have trouble or are advanced admins they can
> turn it off. My personal opinion is that there are too many
> architectures and configurations for you to accurately optimize inside
> your program, and this gives you and your users an easy out.
> 
> if ($do_db_optimization == 1) {
>   $DB->do("SET ENABLE_SEQSCAN TO OFF") || die...
> } else {
>   # do nothing -- postgresql will figure it out
> }

That is a wonderful idea and I already have the foundation in place to 
easily implement this. Thanks!!

Madison

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



view thread (31+ messages)

Message-ID: <42B06660.1060504@alteeve.com>
Permalink:  ../42B06660.1060504@alteeve.com/
Also on:    postgresql.org/message-id/42B06660.1060504@alteeve.com

 · 

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: linux@alteeve.com, karim.nassar@acm.org
  Subject: Re: Index ot being used
  In-Reply-To: <42B06660.1060504@alteeve.com>

* 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