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

help / color / mirror / Atom feed
From: Carlo Stonebanks <stonec.register@sympatico.ca>
To: 'Gavin Flower' <GavinFlower@archidevsys.co.nz>
To: 'Nikolas Everett' <nik9000@gmail.com>
Cc: 'Marc Mamin' <M.Mamin@intershop.de>
Cc: 'Jeff Janes' <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Are bitmap index scans slow to start?
Date: Thu, 28 Feb 2013 15:13:50 -0500
Message-ID: <004601ce15f0$1fc6ce20$5f546a60$@sympatico.ca> (raw)
In-Reply-To: <5127CFF8.4010402@archidevsys.co.nz>
References: <005701ce0fb5$6f841f30$4e8c5d90$@sympatico.ca>
	<001501ce1054$7b518380$71f48a80$@sympatico.ca>
	<CAMkU=1yG884Nak4zPoNHwDGpC7w2nrKH6_xztPw4b7P9am0wdg@mail.gmail.com>
	<B6F6FD62F2624C4C9916AC0175D56D8801B17F@jenmbs01.ad.intershop.net>
	<006201ce1125$2c554150$84ffc3f0$@sympatico.ca>
	<CAPmjWd1On_uAp6suqYoHuh3ksKD0xn6tOhOM_Z2vaweO-vexSA@mail.gmail.com>
	<5127CFF8.4010402@archidevsys.co.nz>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

<<Could you use CLUSTER on the table after it had been closed off?  If
appropriate, that should make the queries run much faster, as elated entries
will be in the same or nearby blocks on disk.

>> 

 

Technically, yes. That would really help, but the issue is scheduling.
Although the logs are closed off for writes, they aren't closed off for
reads, ref PG documentation: "When a table is being clustered, an ACCESS
EXCLUSIVE lock is acquired on it. This prevents any other database
operations (both reads and writes) from operating on the table until the
CLUSTER is finished."

 

Not ideal, but a lot better than doing nothing at all!

view thread (20+ messages)  latest in thread

Message-ID: <004601ce15f0$1fc6ce20$5f546a60$@sympatico.ca>
Permalink:  ../004601ce15f0$1fc6ce20$5f546a60$@sympatico.ca/
Also on:    postgresql.org/message-id/004601ce15f0$1fc6ce20$5f546a60$@sympatico.ca

 · 

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: stonec.register@sympatico.ca, GavinFlower@archidevsys.co.nz, nik9000@gmail.com, M.Mamin@intershop.de, jeff.janes@gmail.com
  Subject: Re: Are bitmap index scans slow to start?
  In-Reply-To: <004601ce15f0$1fc6ce20$5f546a60$@sympatico.ca>

* 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