Re: Seqscan rather than Index

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Seqscan rather than Index
Date: 2004-12-18 13:45:40
Message-ID: 20041218134540.GA25107@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Dec 17, 2004 at 10:39:18PM -0600, Bruno Wolff III wrote:
> It doesn't seem totally out of wack. You will be limited by the memory
> bandwidth and it looks like you get something on the order of a few
> hundred references to memory per row. That may be a little high, but
> it doesn't seem ridiculously high.

I just tested 8.0.0rc1 -- I got a _50%_ speedup on this operation...

/* Steinar */
--
Homepage: http://www.sesse.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Theo Galanakis 2004-12-20 04:17:11 PG Logging is Slow
Previous Message Ron Mayer 2004-12-18 07:51:12 Tips for a system with _extremely_ slow IO?