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

Re: Slow indexscan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikko Partio" <mpartio(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow indexscan
Date: 2007-06-20 19:29:54
Message-ID: 29484.1182367794@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Mikko Partio" <mpartio(at)gmail(dot)com> writes:
> I guess the sort_mem helped, or then part of the rows are in the cache
> already. Should increasing sort_mem help here since there are no sorts etc?

No, it wouldn't --- this change has to be due to the data being already
loaded into cache.

There's no obvious reason for the previous query to be so slow, unless
you've got horrendously slow or overloaded disk hardware.  What sort of
machine is this anyway, and was it doing any other work at the time?

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Andrew SullivanDate: 2007-06-20 19:45:33
Subject: Re: On managerial choosing (was: Postgres VS Oracle)
Previous:From: Shaun ThomasDate: 2007-06-20 19:25:28
Subject: Re: Performance query about large tables, lots of concurrent access

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