Sampling in PostgreSQL
Sometimes there are situations when you need to select a certain number of random entries from the table. Since version 9.5, this feature has appeared. Using TABLESAMPLE, you can not select all the data from the table, but only some of them. Synopsis: SELECT […] FROM table_name TABLESAMPLE sampling_method ( argument [, …] ) [ ….Read more
PostgreSQL 9.6.2 Release Notes in Hebrew
As part of PostgreSQL documentation translation into Hebrew project I’m proud to announce about PostgreSQL 9.6.2 Release Notes translation process completion. The Hebrew Notes are available on link. Comments are welcome. I will continue posting the translation project progress.
The first pgDay in Israel
pgDay Israel 2017, the first event of its kind in Israel fully dedicated to PostgreSQL, was held at Google Campus Tel Aviv on March 2. The event was run by PostgreSQL Israel Community . The event raised great interest among high-tech and security industries, and attended by more than 70 participants from a variety of domains, ….Read more