Hi,
I would suggest if you can try one of this options:
0- create a new index on " inter "column for grille table and in your WHERE
clause try to limit the number of update rows instead of 2mills for one
the whole transaction , something like :where inter > x and inter < y;
1- drop at least t
Hi Andy,
Thank you , please, see bellow my answers:
Andy Colson wrote:
On 05/31/2010 11:05 AM, Isabella Ghiurea wrote:
> Hello PG list,
> I 'm looking for some tip, advice toimprove PG backups performance,
> presently running
> pg_dumpall compressed option on raid array 0
Hello PG list,
I 'm looking for some tip, advice toimprove PG backups performance,
presently running
pg_dumpall compressed option on raid array 0 getting aprox14GB writes
in 45 min, I'm backing up aprox 200GB database cluster daily .
How can I improve this performance with the present hardwar
Dear PG community,
I would like to know if anyone there is using pgsphere ( v 1.1.0) with PG
v 8.3.6 , I have few questions regarding the compatibility of this 2
versions.
Thank you,
Isabella
--
View this message in context:
http://www.nabble.com/Pg-and-pgsphere-users-tp25996708p25996708.htm
