PgSql

[HACKERS] Reposnse from backend when wrong user/database request send
It seems between 8.4 and CVS HEAD backend responses 'E' packet (error/fatal message) if a startup packet sent with wrong user and/or database. Before backend responses 'R' packet first followd by 'E' packet. Does anybody know why this change made? I do not againt this change because this is correct behavior. Jus... 12 Mar 2010 00:41

buildfarm logging versus embedded nulls
Tom Lane wrote: I was looking at this recent nonrepeatable buildfarm failure: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=polecat&dt=2010-03-11%2021:45:10 which has several instances of the known "pgstat wait timeout" problem during the parallel regression tests. I was disappointed to s... 12 Mar 2010 18:26

HeapTupleData.t_self garbage values
"Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> writes: According to htup.h: * t_self and t_tableOid should be valid if the HeapTupleData points * to a disk buffer, or if it represents a copy of a tuple on disk. * They should be explicitly set invalid in manufactured tuples. In the heap_hot_search_b... 11 Mar 2010 17:59

[HACKERS] HeapTupleData.t_self garbage values
According to htup.h: * t_self and t_tableOid should be valid if the HeapTupleData points * to a disk buffer, or if it represents a copy of a tuple on disk. * They should be explicitly set invalid in manufactured tuples. In the heap_hot_search_buffer function of heapam.c this is not true. I can't find a cl... 11 Mar 2010 15:43

[HACKERS] tsearch - using a transformed data files
Hello we are able to go down load time of ispell dictionaries if we can remove upper to lower transformations (and some flag check). these operations take about 40% of dictionary initialisation time. so maybe we can thinking about some flag for ispell_dictionary - like clean, or some similar? Regards Pav... 11 Mar 2010 14:35

[HACKERS] tsearch profiling - czech environment - take 55MB
Hello There are some wrong in our implementation NISortDictionary. After initialisation is ts_cache memory context 55MB long and pg takes 190MB. dispell_init cspell: 1024 total in 1 blocks; 136 free (1 chunks); 888 used After dictionary loading cspell: 3072 total in 2 blocks; 568 free (5 chunks); 2504 used ... 11 Mar 2010 11:09

Can we still trust plperl?
On Thu, Mar 11, 2010 at 09:31:46AM -0500, Andrew Dunstan wrote: Last night my attention was drawn to this: <http://search.cpan.org/~timb/PostgreSQL-PLPerl-Injector-1.002/lib/PostgreSQL/PLPerl/Injector.pm> I'm wondering if we can reasonably continue to support plperl as a trusted language, or at le... 11 Mar 2010 11:09

[HACKERS] Can we still trust plperl?
Last night my attention was drawn to this: <http://search.cpan.org/~timb/PostgreSQL-PLPerl-Injector-1.002/lib/PostgreSQL/PLPerl/Injector.pm> I'm wondering if we can reasonably continue to support plperl as a trusted language, or at least redefine what "trusted" actually means. Does it mean "can't do untrust... 11 Mar 2010 10:02

Assertion failure twophase.c (2) (testing HS/SR)
Erik Rijkers wrote: in a 9.0devel, primary+standby, cvs from 2010.03.04 01:30 With three patches: new_smart_shutdown_20100201.patch extend_format_of_recovery_info_funcs_v4.20100303.patch Got a link to these two patches? I couldn't find them with a quick search. fix-KnownAssignedXidsRem... 12 Mar 2010 03:56

[HACKERS] [patch] build issues on Win32
I've run across a couple of stumbling blocks when building on Win32 (specifically, XP + MinGW): 1. PostgreSQL's private versions of inet_aton etc. can conflict with similar functions in other libraries (in my case, PostgreSQL's inet_aton conflicts with libavformat's). 2. On Win32, PostgreSQL uses the... 10 Mar 2010 09:41