Re: [GENERAL] Autovacuum doesn't work if the table has large number of records

2013-04-13 Thread Ascot Moss
4 05:41:07 HKT,3/0,0,WARNING,01000,"pgstat wait timeout","" 2013-04-14 06:17:02.946 HKT,,,16436,,51699179.4034,1,,2013-04-14 01:10:17 HKT,2/4,0,LOG,0,"automatic vacuum of table ""postgres.public.test"": index scans: 2 pages: 0 removed, 26

Re: [GENERAL] PostgreSQL 9.1.8 Upgrade to 9.1.9

2013-04-13 Thread Ascot Moss
Thanks! It works and my PostgreSQL is now 9.1.9. On Fri, Apr 12, 2013 at 3:46 AM, François Beausoleil wrote: > > Le 2013-04-08 à 22:45, Ascot Moss a écrit : > > I am new to Postgresql. > > > > I have the Postgresql 9.1.8 installed in my Ubuntu 12.04 machine, I > fo

[GENERAL] Autovacuum doesn't work

2013-04-13 Thread Ascot Moss
Hi, I am new to PostgreSQL. I have a PostgreSQL table named "test" with 300,000,000 records inserted, it has only two fields (id, and int i). For testing purposes, after inserts, all records have been updated once in order to make n_dead_tup = 300,000,000 Current PostgreSQL settings: autovacuum

[GENERAL] Autovacuum doesn't work if the table has large number of records

2013-04-13 Thread Ascot Moss
(please ignore if duplicated) Hi, I am new to PostgreSQL. I have a PostgreSQL table named "test" with 300,000,000 records inserted, it has only two fields (id, and int i). For testing purposes, after inserts, all records have been updated once in order to make n_dead_tup = 300,000,000 Current

[GENERAL] PostgreSQL Upgrade from 9.1.8 to 9.1.9

2013-04-11 Thread Ascot Moss
Hi, I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu 12.04 machine and I found 9.1.9 was released last week, can someone advise me how to upgrade pg from 9.1.8 to 9.1.9? or, are the following commands correct for this upgrade? apt-get update apt-get upgrade (os Ubuntu 12

[GENERAL] PostgreSQL 9.1.8 Upgrade to 9.1.9

2013-04-11 Thread Ascot Moss
Hi, I am new to Postgresql. I have the Postgresql 9.1.8 installed in my Ubuntu 12.04 machine, I found 9.1.9 was released last week, can anyone advise me the steps to upgrade 9.1.8 to 9.1.9? o/s: ubuntu 12.04 64-bit current postgresql: 9.1.8 target postgresql: 9.1.9 Is it ok to run "apt-get upda