Skip site navigation (1) Skip section navigation (2)

Re: test / live environment, major performance difference

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Christo Du Preez <christo(at)mecola(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: test / live environment, major performance difference
Date: 2007-06-12 14:30:33
Message-ID: 20070612143033.GA8541@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jun 12, 2007 at 03:32:40PM +0200, Christo Du Preez wrote:
> As an example I took a table with about 650 rows, having a parentid
> field with an index on parentid.

Try a bigger table. Using an index for only 650 rows is almost always
suboptimal, so it's no wonder the planner doesn't use the index.

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

In response to

pgsql-performance by date

Next:From: Bill MoranDate: 2007-06-12 14:37:16
Subject: Re: How much memory PostgreSQL is going to use?
Previous:From: Dave DutcherDate: 2007-06-12 14:28:11
Subject: Re: test / live environment, major performance difference

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group