Re: [PERFORM] TRUNCATE TABLE

2007-08-05 Thread Decibel!
On Sat, Aug 04, 2007 at 11:39:31PM +0200, Adriaan van Os wrote: > Kevin Grittner wrote: > On Mon, Jul 16, 2007 at 7:18 PM, in message > <[EMAIL PROTECTED]>, > >Tom Lane <[EMAIL PROTECTED]> wrote: > >>Somehow, autovac is doing something that makes the filesystem go nuts > >>every so often

Re: [PERFORM] Default Performance between 8.0 and 8.1

2007-08-05 Thread Merlin Moncure
On 8/5/07, Ted Jordan <[EMAIL PROTECTED]> wrote: > We currently have some databases running under 8.0 and 8.1. I have noticed > a significant difference in the time taken to restore dumps between the two > versions, with 8.0 being much faster. For example a dump of a few MB will > take just secon

Re: [PERFORM] Performance problems with large telemetric datasets on 7.4.2

2007-08-05 Thread Heikki Linnakangas
Sven Clement wrote: > OK so beginning on Monday I will test the config on a 8.2.x to verify the > performance issues, but I also found some disturbing info's on the net, that > the index may be corrupted because of the big difference between an index > entry which is deleted and the new value inser