PgSql

testing HS/SR - 1 vs 2 performance
On Sat, Apr 10, 2010 at 8:23 AM, Erik Rijkers <er(a)xs4all.nl> wrote: I understand that in the scale=1000 case, there is a huge cache effect, but why doesn't that apply to the pgbench runs against the standby?  (and for the scale=10_000 case the differences are still rather large) I guess that this perform... 7 May 2010 08:55

pg_ctl stop -m immediate on the primary server inflatessequences
Martijn van Oosterhout �rta: On Sat, Apr 10, 2010 at 02:36:41PM +0200, Boszormenyi Zoltan wrote: The above is quite reproducable, "pg_ctl stop -m immediate" "usually" inflated my serial sequence, but I had two occasions when not. The 69 -> 70 was one. The inflated increase is always 33: ... 12 Apr 2010 04:50

В Э Д компании: особенности таможенного регулирования в рамках Таможенного союзаa
õÞÁÓÔÎÉËÁÍ ÷üä 2I AÐrelÑ ÷ÎÉÍÁÎÉÅ ÉÚÍÅÎÅÎÉÑ ôë òæ Ó 2010 Ç. ó 01 ÑÎ×ÁÒÑ 2010 ÇÏÄÁ ×ÓÔÕÐÉÌÉ × ÓÉÌÕ: ôï÷áòîáñ îïíåîëìáôõòá ÷üä É ôáíïöåîîùê ôáòéæ ôáíïöåîîïçï óïàúá åÄÉÎÙÅ ÐÒÁ×ÉÌÁ ÎÅÔÁÒÉÆÎÏÇÏ ÒÅÇÕÌÉÒÏ×ÁÎÉÑ ÎÁ ÔÅÒÒÉÔÏÒÉÉ ôÁÍÏÖÅÎÎÏÇÏ ÓÏÀÚÁ åÄÉÎÙÅ ÐÒÁ×ÉÌÁ ôáíïöåîîï-ôáòéæîïçï òåçõìéòï÷áîéñ ÎÁ ÔÅÒÒÉÔÏÒÉÉ ÇÏÓÕÄÁÒÓ... 12 Apr 2010 01:36

[HACKERS] Virtual Private Database
Hello, 1) VPD: Virtual Private Database I would appreciate to have a new feature in PostgreSQL. This is an oracle-like feature that implement "Row Level Security". This feature may be emulated by using VIEW/RULE but this is very time consuming and error prone. I would appreciated to have an estimated of the f... 10 Apr 2010 11:17

pg_ctl stop -m immediate on the primary serverinflates sequences
--On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan <zb(a)cybertec.at> wrote: The above is quite reproducable, "pg_ctl stop -m immediate" "usually" inflated my serial sequence, but I had two occasions when not. The 69 -> 70 was one. The inflated increase is always 33: AFAIKS sequences are pre-logged... 10 Apr 2010 16:48

[HACKERS] testing HS/SR - 1 vs 2 performance
Using 9.0devel cvs HEAD, 2010.04.08. I am trying to understand the performance difference between primary and standby under a standard pgbench read-only test. server has 32 GB, 2 quadcores. primary: tps = 34606.747930 (including connections establishing) tps = 34527.078068 (including connections establ... 9 Apr 2010 20:06

GSoC - proposal - Materialized Views in PostgreSQL
pavelbaros <baros.p(a)seznam.cz> wrote: I am also waiting for approval for my repository named "materialized_view" on git.postgresql.org They seem to prefer that you get a repository under your name and use materialized_view as a branch name. See my account on git.postgresql.org and its serializable branc... 23 Apr 2010 21:20

[HACKERS] testing hot standby
Hi, i'm startint to try Hot Standby & Streaming Replication, so i started a replication: 1) Install master server with regression database 2) Start WAL archive (archive_mode=on, archive_command='cp %p /usr/local/pgsql/wal_archive/%f') 3) select pg_start_backup('standby test'); 4) cp -R /usr/local/pgsql/9.0/d... 9 Apr 2010 16:45

[HACKERS] Gsoc XQuery
*IDEA:XMLQuery* * * *Abstract* SQL/XML makes it possible to store your XML documents in your SQL database, to query those documents using XPath and XQuery, and to "publish" your existing SQL data in the form of XML documents. *Benefits of Project* SQL/XML is an ANSI and ISO standard that provides suppo... 9 Apr 2010 12:16

[HACKERS] is_absolute_path incorrect on Windows
Here's a thread that incorrectly started on the security list, but really is more about functionality. Looking for comments: The function is_absolute_path() is incorrect on Windows. As it's implemented, it considers the following to be an absolute path: * Anything that starts with / * Anything that starst with \... 9 Apr 2010 10:00