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.m.guerr...@usit.uio.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
