Re: [PERFORM] Regarding ALTER Command

2006-06-08 Thread Tom Lane
"soni de" <[EMAIL PROTECTED]> writes: > One more thing I have to mention is that we are using 2 postmasters running > on different machines and both are accessing same data directory. (i.e both > the machines uses same tables or the databases) The above is guaranteed NOT to work. I'm surprised yo

Re: [PERFORM] Regarding ALTER Command

2006-06-07 Thread soni de
Hello,   We are planning to use latest postgres version. I have one query as below:   One more thing I have to mention is that we are using 2 postmasters running on different machines and both are accessing same data directory. ( i.e both the machines uses same tables or the databases) In that case

Re: [PERFORM] Regarding ALTER Command

2006-06-07 Thread Jim C. Nasby
On Wed, Jun 07, 2006 at 06:13:11PM +0530, soni de wrote: > Hello, > > > > We have database on which continueous operations of INSERT, DELETE, UPDATE > are going on, In the mean time irrespective of INSERT and UPDATE we want to > ALTER some filelds from the table can we do that? > > Would the AL

[PERFORM] Regarding ALTER Command

2006-06-07 Thread soni de
  Hello,   We have database on which continueous operations of INSERT, DELETE, UPDATE are going on, In the mean time irrespective of INSERT and UPDATE we want to ALTER some filelds from the table can we do that? Would the ALTER command on heavily loaded database create any perfomance problem? I