Re: [GENERAL] Performance problem. Could it be related to 8.3-beta4?

2008-01-10 Thread Gokulakannan Somasundaram
If possible can you send the data dump of these tables. usuarios_temp , usuarios_indice ? Thanks, Gokul. On Jan 10, 2008 4:00 PM, Clodoaldo <[EMAIL PROTECTED]> wrote: > 2008/1/8, Clodoaldo <[EMAIL PROTECTED]>: > > 2008/1/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > > Clodoaldo escribió: > > > > >

Re: [GENERAL] Postgresql simple query performance question

2007-11-06 Thread Gokulakannan Somasundaram
Hi, Oracle, eventhough is a timestamp based database, stores only one version for each row in the table and the rest of the versions of the same-row(which might have got created due to updates) in a separate place called undo log. In postgres, all the versions are stored in the table. So the ta