Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-24 Thread Joshua D. Drake
[mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 3:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [GENERAL][ADMIN][HACKERS]data fragmentation Hi, i have a theorical question. i was thought that data fragmentation can cause a loss of performance when retrieving

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-16 Thread Alvaro Herrera
On Tue, Dec 16, 2003 at 10:29:20PM +, Jaime Casanova wrote: > >On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote: > >>I too had the same problem; There was one query which used to take a > >>very long time. What I did was, I took a backup of the whole database. > >>Reinstal

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-16 Thread Alvaro Herrera
On Fri, Dec 12, 2003 at 09:59:23AM +0530, Somasekhar Bangalore wrote: > Hi, > > I too had the same problem; There was one query which used to take a > very long time. What I did was, I took a backup of the whole database. > Reinstalled postgres on a different mount point and restored the data > b