On Tuesday 29 July 2008, "Francisco Reyes" <lists(at)stringsutils(dot)com> wrote:
> Besides maintenance_work_mem, what else can be changed to improve index
Depends where the bottleneck is.
1 CPU core 100% user/system = buy faster CPU cores.
System in I/O wait = upgrade disk channel.
In response to
pgsql-general by date
|Next:||From: Francisco Reyes||Date: 2008-07-29 19:03:35|
|Subject: Re: Index creation and maintenance_work_mem|
|Previous:||From: Valter Douglas Lisbôa Jr.||Date: 2008-07-29 18:36:23|
|Subject: Re: How do I convert a timestamp with time zone to local time?|