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 */
In response to
pgsql-performance by date
|Next:||From: Bill Moran||Date: 2007-06-12 14:37:16|
|Subject: Re: How much memory PostgreSQL is going to use?|
|Previous:||From: Dave Dutcher||Date: 2007-06-12 14:28:11|
|Subject: Re: test / live environment, major performance difference|