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, and take an astonishingly long time to create an empty
file. But autovac itself does
Hi
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 seconds to load under 8.0 but the same dump will take
Hi everybody,
The bigint problem was probably a typo because I had to type the entire
definitions, as the server is on a vpn and I don't had access with my
machine where I wrote the mail, and the 7.4.2 was surely a typo... ;) I
apology...
OK so beginning on Monday I will test the config on a 8.2.
Hi,
Thanks for the suggestions but apparently the problem in another place.
I have changed the default_statistics_target from to 1000 but the result is
pretty much the same as with when it was 10.
After the change the database was vacuumed and analyzed.
Let me know if I miss anything.
Is there
