Re: [ADMIN] Massive insert created 975 WAL segments.. what?

2012-09-11 Thread Simon Riggs
On 12 September 2012 01:10, Wells Oliver wrote: > We were doing a test and inserted 1.5 million rows. In doing so, postgres > created 974 WAL segments of 16MB apiece. The relevant configuration from my > master's postgresql.conf: > > wal_level = hot_standby > archive_mode = on > archi

Re: [ADMIN] Massive insert created 975 WAL segments.. what?

2012-09-11 Thread Ray Stell
On Sep 11, 2012, at 8:10 PM, Wells Oliver wrote: > So, now I have 16GB of WAL segments, 974 of them. Will postgresql clean this > up? Will it remove these files? Will it create more with big inserts? > > What is the best way to manage this? http://www.postgresql.org/docs/9.2/static/pgarchivecl

[ADMIN] Massive insert created 975 WAL segments.. what?

2012-09-11 Thread Wells Oliver
We were doing a test and inserted 1.5 million rows. In doing so, postgres created 974 WAL segments of 16MB apiece. The relevant configuration from my master's postgresql.conf: wal_level = hot_standby archive_mode = on archive_command = 'test ! -f /mnt/postgresql-logs/%f && cp %p /mn

[ADMIN]

2012-09-11 Thread Wells Oliver
-- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] pg_upgrade with postgis

2012-09-11 Thread Bruce Momjian
On Tue, Sep 11, 2012 at 04:15:31PM +0300, Ronit Allen wrote: > HI - > > I am looking to upgrade our postgresql 9 to 9,2 using pg_upgrade. > > We have postgis installed on the current cluster (9). > > Both postgresql and postgis was installed using the pg repos. > > Will I need to re-install

[ADMIN] Windows Services and Postgresql 9.1.3

2012-09-11 Thread Vincent Dautremont
Hi, I'm using Postgresql 9.1.3 x64 on Windows 2008, I'm doing reliability tests and effects and consequences of a server power failure. What I see is that when Windows reboots from a power failure sometimes the Windows postgresql service is not in sync with the actual state of postgres. For examp

[ADMIN] pg_upgrade with postgis

2012-09-11 Thread Ronit Allen
HI - I am looking to upgrade our postgresql 9 to 9,2 using pg_upgrade. We have postgis installed on the current cluster (9). Both postgresql and postgis was installed using the pg repos. Will I need to re-install postgis after running pg_upgrade? Thanks for any guidance, Ronit

Re: [ADMIN] Large historical tables and autovacuum

2012-09-11 Thread Albe Laurenz
David Morton wrote: >>> We have many large tables which contain static historical data, they are auto vacuumed on >>> a regular basis (sometimes to prevent wraparound) which i suspect causes a few annoying side effects: >>> - Additional WAL file generation >>> - Increased 'changed' data as far as o