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

help / color / mirror / Atom feed
From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-sql@postgresql.org
Subject: Re: How to speed up the database query?
Date: Thu, 27 Oct 2005 09:44:53 +0200
Message-ID: <20051027074453.GA4136@kaufbach.delug.de> (raw)
In-Reply-To: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>
References: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>

Abdul Wahab Dahalan <wahab@mimos.my> schrieb:

> Hi everyone!
> 
> I'm looking for solution to speed up the database query, means that to
> get resultset as quicker as we can.

09:41 < akretschmer> ??tuning
09:41 < rtfm_please> For information about tuning
09:41 < rtfm_please> see http://www.powerpostgresql.com
09:41 < rtfm_please> or http://www.powerpostgresql.com/PerfList
09:41 < rtfm_please> or http://www.varlena.com/varlena/GeneralBits/116.php


> 
> For example if I've 700 records in the table it will take longer time
> compared if I've only 20 records. How do we speed up the query?. Any
> query technique that can be applied?.

Read the links above. You should use Indexe for searching. And you
should use 'explain select ...' to see how the planer works.

09:43 < akretschmer> ??explain
09:43 < rtfm_please> For information about explain
09:43 < rtfm_please> see http://techdocs.postgresql.org/oscon2005/robert.treat/OSCON_Explaining_Explain_Public.sxi
09:43 < rtfm_please> or http://www.gtsm.com/oscon2003/toc.html
09:43 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-explain.html


Regards, Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°



view thread (6+ messages)  latest in thread

Message-ID: <20051027074453.GA4136@kaufbach.delug.de>
Permalink:  ../20051027074453.GA4136@kaufbach.delug.de/
Also on:    postgresql.org/message-id/20051027074453.GA4136@kaufbach.delug.de

 · 

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-sql@postgresql.org
  Cc: akretschmer@spamfence.net
  Subject: Re: How to speed up the database query?
  In-Reply-To: <20051027074453.GA4136@kaufbach.delug.de>

* 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