Skip site navigation (1) Skip section navigation (2)

Re: Problemas con COPY

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: Jose David Verbel Tous <jverbel(at)solati(dot)com(dot)co>
Cc: Carlos Edward Grajales Marmolejo <cgrajales(at)colombiasoftware(dot)net>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Problemas con COPY
Date: 2011-03-24 07:58:07
Message-ID: 4D8AF98F.2090302@usit.uio.no (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jose David Verbel Tous wrote:
> Saludos,
> 
> 
> Son cerca de 1 millón de Registros
> 
> No hay indices, llaves ni triggers.
> 

Puedes mandarnos el resultado de ejecutar esta sentencia SQL en tu
servidor?:

SELECT
   name,current_setting(name)
FROM pg_settings
WHERE NOT source='default' AND NOT name IN
  ('DateStyle','lc_messages','lc_monetary','lc_numeric','lc_time',
  'lc_collate','lc_ctype','TimeZone','timezone_abbreviations',
  'default_text_search_config','application_name');



- --
 Rafael Martinez Guerrero
 Center for Information Technology
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk2K+Y8ACgkQBhuKQurGihTHoQCdGhV1FATdTIeYWWmA++2Qwv6N
rGkAnRsynRe4RksB0EpEwkFwMEwMPSvb
=tXM3
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-es-ayuda by date

Next:From: Emanuel Calvo FrancoDate: 2011-03-24 11:24:21
Subject: Re: insert con serial
Previous:From: Alvaro HerreraDate: 2011-03-23 22:01:06
Subject: Re: sobre pg_stat_all_tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group