| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Jens Hoffrichter <jens(dot)hoffrichter(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: SeqScans on boolen values / How to speed this up? |
| Date: | 2010-07-06 02:42:36 |
| Message-ID: | 4C32981C.2070406@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-07-06 03:19:44 | Re: SeqScans on boolen values / How to speed this up? |
| Previous Message | Robert Haas | 2010-07-06 00:34:51 | Re: Performance issues with postgresql-8.4.0: Query gets stuck sometimes |