Re: [PERFORM] BUG #1697: Select getting slower on continously updating data

2005-06-05 Thread Bahadur Singh
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote: > This does not belong on the pgsql-bugs list. The > pgsql-novice or > pgsql-performance lists seem more appropiate. I have > set followups > to the pgsql-novice list. > > On Thu, Jun 02, 2005 at 12:05:00 +0100, > Bahadur Singh <[EMAIL PROTECTED]

Re: [PERFORM] BUG #1697: Select getting slower on continously updating data

2005-06-03 Thread Bruno Wolff III
On Fri, Jun 03, 2005 at 00:09:00 -0700, Bahadur Singh <[EMAIL PROTECTED]> wrote: > > Many thanks for this tip ! > But is this good idea to analyse/vacuuming the > database tables while updates are taking place.. > Since, I update continuously say (100,000 ) times or > more the same data set. >