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

help / color / mirror / Atom feed

From: John Vincent <lusis.org@gmail.com>
To: Mark Lewis <mark.lewis@mir3.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Optimizer internals
Date: Thu, 15 Jun 2006 15:38:32 -0400
Message-ID: <c841561b0606151238m333ca5cdgccd066b980a29aac@mail.gmail.com> (raw)
In-Reply-To: <c841561b0606151221v219987aap376194583dd30940@mail.gmail.com>
References: <c841561b0606151105v459d830era158b9eea5f59a7e@mail.gmail.com>
	<1150396425.31200.66.camel@archimedes>
	<c841561b0606151146j5f8410f2qaeaff7649b70cd20@mail.gmail.com>
	<1150398064.31200.76.camel@archimedes>
	<c841561b0606151221v219987aap376194583dd30940@mail.gmail.com>

Any suggestions? FYI the original question wasn't meant as a poke at
> comparing PG to MySQL to DB2. I'm not making an yvalue judgements either
> way. I'm just trying to understand how we can use it the best way possible.
>

Actually we just thought about something. With PG, we can create an index
that is a SUM of the column where indexing, no? We're going to test this in
a few hours. Would that be able to be satisfied by an index scan?

view thread (17+ messages)  latest in thread

Message-ID: <c841561b0606151238m333ca5cdgccd066b980a29aac@mail.gmail.com>
Permalink:  ../c841561b0606151238m333ca5cdgccd066b980a29aac@mail.gmail.com/
Also on:    postgresql.org/message-id/c841561b0606151238m333ca5cdgccd066b980a29aac@mail.gmail.com

copy link · copy postgr.es

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: lusis.org@gmail.com, mark.lewis@mir3.com
  Subject: Re: Optimizer internals
  In-Reply-To: <c841561b0606151238m333ca5cdgccd066b980a29aac@mail.gmail.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