From: Craig Ringer <craig@postnewspapers.com.au>
To: Jens Hoffrichter <jens.hoffrichter@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: SeqScans on boolen values / How to speed this up?
Date: Tue, 06 Jul 2010 10:42:36 +0800
Message-ID: <4C32981C.2070406@postnewspapers.com.au> (raw)
In-Reply-To: <AANLkTimprnFkqv_Z9uDuwW1u2iok75Zn1N1jMiYI8fWy@mail.gmail.com>
References: <AANLkTimprnFkqv_Z9uDuwW1u2iok75Zn1N1jMiYI8fWy@mail.gmail.com>
On 05/07/10 19:36, Jens Hoffrichter wrote:
> Hello everyone,
>
> We've recently finished developing a bigger webapplication, and we are
> about to put it online.
>
> I ran some load tests yesterday, and configured 'slow query' logging
> beforehand, so I could see if there might be a performance bottleneck
> in the PG. While I discovered no real problems, the log file analysis
> using pgFouine revealed two queries, which are executed often, and
> take quite a bit some time.
It might be worth looking at what queries have results that change
infrequently or don't have to be up to the minute accurate, so they're
candidates for caching. Memcached is an incredibly handy tool for taking
load off your database.
--
Craig Ringer
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: craig@postnewspapers.com.au, jens.hoffrichter@gmail.com
Subject: Re: SeqScans on boolen values / How to speed this up?
In-Reply-To: <4C32981C.2070406@postnewspapers.com.au>
* 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