On Wed, Apr 4, 2012 at 10:12 AM, Bèrto ëd Sèra wrote:
> Hi Matheus,
>
> thanks but, as said before "there is not enough information for us to be
> sure that we can add read permission to the group without impact"... any
> other way to extract the same info?
>
> Bèrto
>
> On 4 April 2012 12:24, Mat
superman0920 wrote:
> i have a table which has 850 rows record, i run 30 threads to
> update the record.
> i find the database of processing data speed so slow, per thread
> updating 1000 rows need take 260s
> How to configure the database to make processing speed faster ?
Performance iss
Hi Matheus,
thanks but, as said before "there is not enough information for us to be
sure that we can add read permission to the group without impact"... any
other way to extract the same info?
Bèrto
On 4 April 2012 12:24, Matheus de Oliveira wrote:
> Give read permissions to the group on the d
dear all,
i have come to face the following situation:
-initially the server was 8.4.7
-i used pg_upgrade --link so that the upgrade would be quick
-i created a new tablespace with the intention of moving all the indexes
there (different partition)
-when issueing a statement like 'alter index xxx
Give read permissions to the group on the data directory and archives:
chmod g+r -R /var/lib/pgsql/data
I think just that will solve the problem, as you said that the agent is
already been executed with postgres group.
Regards,
--
Matheus de Oliveira
Bacharelado em Ciências de Computação
Labora
Hi all,
I'm implementing a PG monitoring system on zabbix, using
http://bucardo.org/wiki/Check_postgres
Everything's fine, however I cannot seem to use action=checkpoint without
some intervention on permissions.
See http://bucardo.org/check_postgres/check_postgres.pl.html#checkpoint
The data dir
