Re: [GENERAL] Format

På mandag 28. september 2015 kl. 14:45:00, skrev Ramesh T < rameshparnandit...@gmail.com >: Hi All,           How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.   any help appreciated..   Use IntelliJ

Re: [GENERAL] WAL Shipping and streaming replication

On Mon, Sep 28, 2015 at 12:53:37PM -0600, Scott Marlowe wrote: > The issue was reported as omnipitr-cleanup is SLOOOW, so we run > purgewal by hand, because the cleanup is so slow it can't keep up. But > running it by hand is not supported. > > We fixed the problem though, we wrote out own script

[GENERAL] Serialization errors despite KEY SHARE/NO KEY UPDATE

Using 9.3.9 and 9.4.4 I'm experiencing serialization errors that I have trouble explaining based on the documentation. The concurrent transactions are framework-driven and all of them are running in REPEATABLE READ isolation level. The error can be reproduced as shown below. T1 fails when acquir

Re: [GENERAL] pgpgout/s without swapping--what does it mean?

Hi , Me too have the same issue on PosgreSQL server. pgpgout/s is going high and the same time didn't observe any swapping or memory pressure on the host. Please refer below sar O/P. 12:00:01 PM pgpgin/s pgpgout/s fault/s majflt/s pgfree/s pgscank/s pgscand/s pgsteal/s%vmeff 12:10:01 PM

Re: [GENERAL] Format

On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T wrote: > in my mind to be beautiful ,avoid confusion to understand sql query code > > like > > select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ; > > if some one written, then newer or code reader understand easily > select abcd, >

Re: [GENERAL] pg_restore fails to restore sequences

I believe our BDR build was from before May so that further explains the issue. Sounds like this will not be a problem in the future. Thanks for the help. On Mon, Sep 28, 2015 at 4:49 PM, Alvaro Herrera wrote: > Tom Lane wrote: > > Thom Brown writes: > > > On 28 September 2015 at 22:21, Spencer

[GENERAL] 9.4 and centos/yum multiversion installs

I have a CentOS 6 server thats already running 9.0, ... 9.3 for development. I added 9.4 to it by ... yum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm yum install postgresql94{,-devel,-server,-contrib} I created /etc/sysconfig/pgsql/postgres

[GENERAL] Postgresql 9.4 and ZFS?

Does anybody here have any recommendations for using PostgreSQL 9.4 (latest) with ZFS? We've been running both on ZFS/CentOS 6 with excellent results, and are considering putting the two together. In particular, the CoW nature (and subsequent fragmentation/thrashing) of ZFS becomes largely irr

Re: [GENERAL] 9.4 and centos/yum multiversion installs

On 9/29/2015 10:09 AM, John R Pierce wrote: does the 9.4 yum install no longer support using the sysconfig settings fragments ? I see what looks like the correct shell code for it in /etc/rc.d/init.d/postgresql-9.4 ... # Override defaults from /etc/sysconfig/pgsql if file is present [

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 9/29/2015 10:01 AM, Benjamin Smith wrote: Does anybody here have any recommendations for using PostgreSQL 9.4 (latest) with ZFS? For databases, I've always used mirrored pools, not raidz*. put pgdata in its own zfs file system in your zpool. on that dedicated zfs, set the blocksize to 8k.

Re: [GENERAL] Format

On 09/29/2015 06:13 AM, Ramesh T wrote: On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T mailto:rameshparnandit...@gmail.com>> wrote: in my mind to be beautiful ,avoid confusion to understand sql query code like select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ;

Re: [GENERAL] Format

Nice, thank you. On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver wrote: > On 09/29/2015 06:13 AM, Ramesh T wrote: > >> >> >> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > > wrote: >> >> in my mind to be beautiful ,avoid confusion to understand sql query >>

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Tuesday, September 29, 2015 10:35:28 AM John R Pierce wrote: > On 9/29/2015 10:01 AM, Benjamin Smith wrote: > > Does anybody here have any recommendations for using PostgreSQL 9.4 > > (latest) with ZFS? > > For databases, I've always used mirrored pools, not raidz*. > put pgdata in its own zf

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Tue, Sep 29, 2015 at 01:08:20PM -0700, Benjamin Smith wrote: > On Tuesday, September 29, 2015 10:35:28 AM John R Pierce wrote: > > On 9/29/2015 10:01 AM, Benjamin Smith wrote: > > > Does anybody here have any recommendations for using PostgreSQL 9.4 > > > (latest) with ZFS? > > > > For database

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 9/29/2015 1:08 PM, Benjamin Smith wrote: put pgdata in its own zfs file system in your zpool. on that dedicated >zfs, set the blocksize to 8k. Based on my reading here, that would be -o ashift=13 ? HowDoesZFSonLinuxHandleAdvacedFormatDrives EG: 2^13 = 8192 sorry, I meant recordsize.

Re: [GENERAL] Postgresql 9.4 and ZFS?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Benjamin, if you're using compression, forget about that. You need to synchronize the ashift value to the internal rowsize of you SSD, that's it. Make sure your SSD doesn't lie to you regarding writing blocks and their respective order. In that c

Re: [GENERAL] Postgresql 9.4 and ZFS?

I use pg with zfs on freebsd,it work great.I test zol 1 years ago,it will crash the os on load. Some note for pg on freebsd from my experience: 1.if you use compression,8k recordsize make the compression ratio poor.I reach 7.x with gzip using default record size(128k if I remember) while get 2.x