Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Adding and filling new column on big table
- From: Francisco Reyes <lists(at)stringsutils(dot)com>
- To: Jonathan Blitz <jb(at)anykey(dot)co(dot)il>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Adding and filling new column on big table
- Date: Tue, 30 May 2006 16:52:32 -0400
Jonathan Blitz writes:
I suppose I could do but I need to install PostgreSQL there and then copy over the database. Maybe I will give it a try.
I really think that is your best bet.If for whatever reason that will not be an option perhaps you can just let the process run over the weekend.. possibly monitor the process from the OS to make sure it is not frozen.
Don't recall if you mentioned the OS.. is it any unix like os?If so there are several ways you could check to make sure the process is not frozen such as iostats, top, vmstats(these from FreeBSD, but most unix like os should have tools like those if not some with the same name).
- References:
- Re: Adding and filling new column on big table
- From: Jonathan Blitz
- Re: Adding and filling new column on big table
- Prev by Date: Re: Adding and filling new column on big table
- Next by Date: Re: INSERT OU UPDATE WITHOUT SELECT?
- Previous by thread: Re: Adding and filling new column on big table
- Next by thread: Performance incorporate with JReport
- Indexes: