Hi
i´m using PostgreSQL on windows 2000, the pg_dump take around 50 minutes
to do backup of 200Mb data ( with no compression, and 15Mb with
compression), but in windows XP does not pass of 40 seconds... :(
This happens with 8.1 and version 8.0, somebody passed for the same
situation?
It will b
lto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 30 de novembro de 2005 10:57
Para: Franklin Haut; pgsql-performance@postgresql.org
Assunto: Re: [PERFORM] pg_dump slow
At 08:35 AM 11/30/2005, Franklin Haut wrote:
>Hi
>
>i´m using PostgreSQL on windows 2000, the pg_dump take around 50
>m
, 30 de novembro de 2005 13:57
Para: Ron
Cc: pgsql-performance@postgresql.org; Franklin Haut
Assunto: RE: [PERFORM] pg_dump slow
> At 08:35 AM 11/30/2005, Franklin Haut wrote:
> >Hi
> >
> >i´m using PostgreSQL on windows 2000, the pg_dump take around 50
> >minutes to do
I Maked a new install on machine this night, and the same results, on
console localhost
Windows 2000 Server
Version 5.00.2195
PG Version 8.1
Franklin
>Franlin: are you making pg_dump from local or remote box and is this a
>clean install? Try fresh patched win2k install and see what happen
Hi,
Finally i found the problem of slow backup/restore, i´m only instaled de
Windows 2000 Service Pack 4... :)
Thanks to all
Franklin
-Mensagem original-
De: Richard Huxton [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de
novembro de 2005 14:28
Para: Franklin Haut
Cc
Hello,
I´m have some problems with a temporary table, i need create a table, insert
some values, make a select and at end of transaction the table must droped,
but after i created a table there not more exist, is this normal ?
How to reproduce :
CREATE TEMP TABLE cademp (
Ok, it works.
Thanks
Franklin
-Mensagem original-
De: Larry Rosenman [mailto:[EMAIL PROTECTED]
Enviada em: sexta-feira, 23 de junho de 2006 19:08
Para: 'Franklin Haut'; pgsql-performance@postgresql.org
Assunto: RE: [PERFORM] Temporary table
Franklin Haut wrote:
> He
