Phone: +972 54 305 7642 Email: info@postgrespro.co.il

PostgreSQL Blog

Postgres Miktzoanim
  • 16 Jun

    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...

  • 26 Mar

    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.

  • 19 Mar

    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...