Re: GIN Index for low cardinality

2018-10-26 Thread Ozz Nixon
Jeff, Great info! Your example on Mr. Mrs. Miss, etc. is there a good rule of thumb that if the data is under "x"KB an index is overhead not help? I am not worried about space, more interested in performance.

Re: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB

2018-10-18 Thread Ozz Nixon
There are many possible problems, could you share your command line? For example. Dump on SAME drive as the DB files, can produce disk contention. Dump across the network, can have packet collision of network latency. I dump 20gb test server in a matter of a couple minutes here. But, I run multipl

Re:

2018-06-13 Thread Ozz Nixon
Ok. On Wed, Jun 13, 2018 at 12:00 PM Caglar Aksu wrote: > Dont mail me plase unsubscribe >

RE: Code of Conduct plan

2018-06-05 Thread Ozz Nixon
Sorry... > 1) CoC might result in developers leaving projects I know this on going regurgitation is going to cause my team to leave the project, right around 100 posts on this off topic topic it was bad enough when the original idea came up (2 years ago I think). It used to be exc

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
Thanks Ron, I was trying to find that -- memory had it down as "Persona" and I could not find that, haha. On Fri, Apr 20, 2018 at 8:39 PM Ron wrote: > > Also, Percona (a MySQL fork) 5.7. > > On 04/20/2018 07:31 PM, Ozz Nixon wrote: > > PS. the following databa

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
the key is public (dumb) https://www.postgresql.org/message-id/ca%2bcsw_tb3bk5i7if6inzfc3yyf%2b9hevnty51qfboeuk7ue_v%...@mail.gmail.com Just because you do not see the reason for it, does not make the reason a bad idea. On Fri, Apr 20, 2018 at 8:19 PM Ozz Nixon wrote: > Well, actually since 2

Re: Postgresql database encryption

2018-04-20 Thread Ozz Nixon
Well, actually since 2003, this has been a standard requirement from the Credit Card industry. And it does make sense in the field of "while at rest" the data still cannot be accessed. Requirement 1. No NPI data should be displayed without controls - e.g. reports, PDF, etc. Requirement 2. Same dat

Re: how to securely delete the storage freed when a table is dropped?

2018-04-13 Thread Ozz Nixon
There are free utilities that do government leave wipes. The process would be, drop the table, shrink the old table space then (if linux based), dd fill the drive, and use wipe, 5x or 8x deletion to make sure the drive does not have readable imprints on the platers. Now what Jonathan mentions -