Re: [PERFORM] Help with count(*)

2003-11-15 Thread Dennis Bjorklund
On Fri, 14 Nov 2003, Tom Lane wrote: > I believe the previous discussion also agreed that we wanted to postpone > the freezing of now(), which currently also happens at BEGIN rather than > the first command after BEGIN. Or should that happen at the first call to now()? /me should ge back and try

Re: [PERFORM] INSERT extremely slow with large data sets (fwd)

2003-11-15 Thread George Essig
--- Slavisa Garic <[EMAIL PROTECTED]> wrote: > Does VACUUM ANALYZE help with the analysis or it also speeds up the > process. I know i could try that before I ask but experiment is running > now and I am too curious to wait :), > > Anyway thanks for the hint, > Slavisa > VACUUM ANALYZE will rec

Re: [PERFORM] Error in transaction processing

2003-11-15 Thread radha.manohar
When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, "Postgres signalled to us that we cannot start, commit or rollback the transaction" I don't find any mistakes in the trans

Re: [PERFORM] Help with count(*)

2003-11-15 Thread Neil Conway
Tom Lane <[EMAIL PROTECTED]> writes: > (I believe the previous discussion also agreed that we wanted to > postpone the freezing of now(), which currently also happens at > BEGIN rather than the first command after BEGIN.) That doesn't make sense to me: from a user's perspective, the "start of the