Re: Problemas con COPY

Saludos,

Esta es la respuesta de la sentencia SQL

"add_missing_from"

"on"

"autovacuum"

"off"

"client_encoding"

"SQL_ASCII"

"config_file"

"/var/lib/pgsql/data/postgresql.conf"

"data_directory"

"/var/lib/pgsql/data"

"default_with_oids"

"on"

"hba_file"

"/var/lib/pgsql/data/pg_hba.conf"

"ident_file"

"/var/lib/pgsql/data/pg_ident.conf"

"listen_addresses"

"*"

"log_timezone"

"America/Bogota"

"maintenance_work_mem"

"740MB"

"max_connections"

"100"

"max_stack_depth"

"7MB"

"port"

"5432"

"server_encoding"

"SQL_ASCII"

"shared_buffers"

"2GB"

"transaction_isolation"

"read committed"

"transaction_read_only"

"off"

"work_mem"

"256MB"

On 24 March 2011 02:58, Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> wrote:

> -----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-----
>

--
Jose David Verbel Tous
Ingeniero de Desarrollo
Solati Ltda
Tel: +571 6373721 Ext 103
Autopista Norte Nº 114 78 Oficina 501
Edifiicio Spectrum
Bogota D.C