Lists: | pgsql-es-ayudapgsql-hackers |
---|
From: | Khee Chin <kheechin(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Show method of index |
Date: | 2009-05-08 22:13:38 |
Message-ID: | 797115b80905081513o49e1e1cfk8142fdf9be567af3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-es-ayuda pgsql-hackers |
> Hi,
> I think that can be useful the command \di on psql show the method of
> index (hash, btree, ...) like:
> test=# \di
> List of relations
> Schema | Name | Type | Owner | Table | Method
> --------+---------------+-------+------------+--------+--------
> public | test_id_idx | index | postgresql | table1 | btree
> public | test_name_idx | index | postgresql | table1 | hash
> (2 rows)
Attached is a simple patch which adds the above mentioned functionality to psql.
Regards,
Khee Chin.
Attachment | Content-Type | Size |
---|---|---|
index_patch | application/octet-stream | 1.2 KB |
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Khee Chin <kheechin(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Show method of index |
Date: | 2009-05-08 22:20:02 |
Message-ID: | 20090508222002.GM10794@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-es-ayuda pgsql-hackers |
Khee Chin escribió:
> > Hi,
>
> > I think that can be useful the command \di on psql show the method of
> > index (hash, btree, ...) like:
>
> > test=# \di
> > List of relations
> > Schema | Name | Type | Owner | Table | Method
> > --------+---------------+-------+------------+--------+--------
> > public | test_id_idx | index | postgresql | table1 | btree
> > public | test_name_idx | index | postgresql | table1 | hash
> > (2 rows)
>
> Attached is a simple patch which adds the above mentioned functionality to psql.
Please add it to wiki.postgresql.org/wiki/CommitFestInProgress
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From: | Khee Chin <kheechin(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Show method of index |
Date: | 2009-05-09 00:05:24 |
Message-ID: | 797115b80905081705y14900764i2425b04e7cf51536@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-es-ayuda pgsql-hackers |
>
> Please add it to wiki.postgresql.org/wiki/CommitFestInProgress
>
Submitted under http://wiki.postgresql.org/wiki/CommitFest_2009-First#Clients
Regards,
Khee Chin.
From: | Eddy Ernesto Baños Fernández <eebanos(at)estudiantes(dot)uci(dot)cu> |
---|---|
To: | "'Postgres Ayuda'" <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | ayuda pglb en cybercluster |
Date: | 2009-05-09 00:34:13 |
Message-ID: | 00b801c9d03d$e0b105d0$a2131170$@uci.cu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-es-ayuda pgsql-hackers |
Hola lista:
Estoy intentando implementar un entorno de producción con PostgreSQL utilizando Cybercluster, esta herramienta cuenta con un servicio de balance de carga pglb basado en pgPool, tengo el siguiente problema:
En el archivo de configuración del balanceador pglb.conf aparece la opción <Use_Connection_Pooling>yes/no</ Use_Connection_Pooling>, mi pregunta es a cuantas conexiones él le hace pooling, en pgPool estos parámetros son configurables:
num_init_children
child_max_connections
max_pool
pero en el el pglb no aparece manera de configurar estos parámetros sin embargo en el código fuente del pglb sí se tienen en cuenta e incluso aparentemente referencian a archivos de configuración del pgPool:
en pglb.h
/* configuration file name */
#define POOL_CONF_FILE_NAME "pgpool.conf"
#define HBA_CONF_FILE_NAME "pool_hba.conf"
Ahora, estos ficheros no están en el sistema en ninguna parte, como puedo configurar estos parámetros??
Gracias de antemano.
Eddy
Linux Registered User #411078