Re: [PERFORM] pg_repack solves alter table set tablespace lock

On Fri, Jan 24, 2014 at 3:48 PM, Ying He wrote: > I looked at the pg_repack usage and in release 1.2 > http://reorg.github.io/pg_repack/. there is -s tablespace that claims to > be an online version of ALTER TABLE ... SET TABLESPACE > > is this the functionality that solves the alter table set ta

[PERFORM] pg_repack solves alter table set tablespace lock

hi, all, I have a requirement to move a table to a different storage. I will create the tablespace and use alter table set tablespace to achieve it. The concern is that the table is pretty big and during the set tablespace, application could insert/update/delete records. If there is a lock dur

Re: [PERFORM] PostgreSQL 9.3.2 Performance issues

"fburg...@radiantblue.com" wrote: > We have 64GB of Memory on RHEL 6.4 > > shared_buffers = 8GB > work_mem = 64MB > maintenance_work_mem = 1GB > effective_cache_size = 48GB > Do these settings look correct for 9.3.2? Maybe. What is your max_connections setting? I find that a good place to sta

[PERFORM] PostgreSQL 9.3.2 Performance issues

We have 64GB of Memory on RHEL 6.4 shared_buffers = 8GB work_mem = 64MB maintenance_work_mem = 1GB effective_cache_size = 48GBI found this list of recommended parameters for memory management in PostgreSQL. About shared_buffers: Below 2GB, set to 20% of total system memory.Below 32GB, set to 25%