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

Re: two queries and dual cpu (perplexed)

From: "Dave Held" <dave(dot)held(at)arrayservicesgrp(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: two queries and dual cpu (perplexed)
Date: 2005-04-26 14:58:00
Message-ID: 49E94D0CFCD4DB43AFBA928DDD20C8F9026184DB@asg002.asg.local (view raw or flat)
Thread:
Lists: pgsql-performance
> -----Original Message-----
> From: Shoaib Burq (VPAC) [mailto:sab(at)vpac(dot)org]
> Sent: Tuesday, April 26, 2005 9:31 AM
> To: Tom Lane
> Cc: John A Meinel; Russell Smith; Jeff; 
> pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] two queries and dual cpu (perplexed)
> 
> 
> OK ... so just to clearify...  (and pardon my ignorance):
> 
> I need to increase the value of 'default_statistics_target' 
> variable and then run VACUUM ANALYZE, right?

Not necessarily.  You can set the statistics for a single
column with ALTER TABLE.

> If so what should I choose for the 'default_statistics_target'?
> [...]

Since you have a decently large table, go for the max setting
which is 1000.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

pgsql-performance by date

Next:From: John A MeinelDate: 2005-04-26 15:05:26
Subject: Re: two queries and dual cpu (perplexed)
Previous:From: Shoaib Burq (VPAC)Date: 2005-04-26 14:31:18
Subject: Re: two queries and dual cpu (perplexed)

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