PgSql

[HACKERS] Prepared query parsing much slower in 9.0?
All, Wheeler has been doing some head-to-head performance testing of Bricolage performance on 8.4 vs. 9.0. So far, 9.0 has been slower, and I've been trying to track down the particular areas where it is. One appears to be prepared query parsing. One test of the Bricolage test suite creates 89 new prepared q... 6 Apr 2010 02:05

[HACKERS] Show schema name on REINDEX DATABASE
Patch attached to show the schema *and* table name when doing a REINDEX DATABASE. -- Greg Sabino Mullane greg(a)endpoint.com greg(a)turnstep.com End Point Corporation PGP Key: 0x14964AC8 ... 5 Apr 2010 13:52

pgsql: Check compulsory parametersin recovery.conf in standby_mode, per
Simon Riggs wrote: I am very disconcerted that there are still no docs whatsoever to describe how the server works in these new modes. I did add a few paragraphs last week, see http://developer.postgresql.org/pgdocs/postgres/warm-standby.html#STANDBY-SERVER-OPERATION. It doesn't explicitly talk about that co... 6 Apr 2010 04:14

Autonomous transaction
On Sun, Apr 4, 2010 at 10:26 AM, Loïc Vaumerel <shefla(a)gmail.com> wrote: Is there a way to use real and clean autonomous transactions in PostgreSQL yet ? No. If no, is it planned to do so ? When ? To my knowledge, no one is working on this. ....Robert -- Sent via pgsql-hackers mailing list (pgs... 13 Apr 2010 20:42

[HACKERS] Autonomous transaction
Hi, I have an application project based on a database. I am really interested in using PostgreSQL. I have only one issue, I want to use autonomous transactions to put in place a debug / logging functionality. To do so, I insert messages in a "debug" table. The problem is, if the main transaction / process rol... 5 Apr 2010 10:29

VACUUM FULL during initdb
Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: Do we still need VACUUM FULL in initdb? VACUUM FULL in 9.0 rewrites all tables, so those operations are a little more expensive than previous releases. Is it worth replacing them into VACUUM? I had left it that way intentionally to make sure there wa... 5 Apr 2010 10:29

contrib check fail at pgcrypto on Windows Server 2008 64bit 9.0dev (HEAD near alpha5)
On Mon, Apr 5, 2010 at 07:16, TAKATSUKA Haruka <harukat(a)sraoss.co.jp> wrote: Hi, all. I built pgsql with following regulation (for buildfarm new entry).  - Windows Server 2008 64bit  - VC2005  - 9.0dev (HEAD near alpha5) 64bit And I got a fail at "vcregress contribcheck" about only pgcrypto. ... 5 Apr 2010 09:23

pgsql: Check compulsory parameters inrecovery.conf in standby_mode, per
On Mon, 2010-04-05 at 17:08 +0900, Fujii Masao wrote: On Sat, Apr 3, 2010 at 6:50 AM, Simon Riggs <sriggs(a)postgresql.org> wrote: Log Message: ----------- Check compulsory parameters in recovery.conf in standby_mode, per docs. On the recent discussion (*1), some people argued that specifying nei... 5 Apr 2010 14:59

[HACKERS] contrib check fail at pgcrypto on Windows Server 2008 64bit 9.0dev(HEAD near alpha5)
Hi, all. I built pgsql with following regulation (for buildfarm new entry). - Windows Server 2008 64bit - VC2005 - 9.0dev (HEAD near alpha5) 64bit And I got a fail at "vcregress contribcheck" about only pgcrypto. All CREATE FUNCTION of pgcrypto got ERROR. (It passed "vcregress check") STATEMENT: CREAT... 5 Apr 2010 02:54

[HACKERS] dmetaphone woes
While testing pgindent the other day, I found some infelicities in contrib/fuzzystrmatch/dmetaphone.c. From pgindent's point of view, the problem is that the code contains two characters in case labels with the high bits set, and this blows pgindent up on my Linux box if the locale happens be en_US.utf8 inste... 4 Apr 2010 22:35