Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuum/Analyze (suddenly) too slow
- From: Gregory Stark <stark(at)enterprisedb(dot)com>
- To: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
- Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Vacuum/Analyze (suddenly) too slow
- Date: Sun, 30 Sep 2007 11:41:06 +0100
"Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com> writes: > A vacuum analyze that used to take about 3 minutes on a table of about > 4 million rows is now taking up to 25 minutes. I changed the > statistics on two index columns to 100 recently, to improve planner > estimates. Could this have something to do with the lack of speed? That sounds about right. It's sampling 10x as much of the table and it's taking almost 10x as long... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
- References:
- Vacuum/Analyze (suddenly) too slow
- From: Phoenix Kiula
- Vacuum/Analyze (suddenly) too slow
- Prev by Date: Vacuum/Analyze (suddenly) too slow
- Next by Date: Re: Please change default characterset for database cluster
- Previous by thread: Vacuum/Analyze (suddenly) too slow
- Next by thread: windows and pg 8.2 (change database to another server)
- Indexes: