PgSql

An idle thought
Greg Stark <stark(a)mit.edu> writes: However then I started thinking about this case and wondered if it wouldn't be possible to optimize. One of the suggested optimizations was to look at using TRUNCATE. But I wonder why it's necessary to use a dedicated command. Shouldn't it be possible for the system to not... 22 Mar 2010 18:04

[HACKERS] An idle thought
A few days ago there was a thread on one of our lists where someone was suprised it took as much i/o to delete data as it took to insert it in the first place. At first this does seem surprising but the fact that Postgres stores its transaction information inline with the data and does all i/o in blocks makes this ... 16 Mar 2010 12:32

Bug in 9.0Alpha4
Hi, I think, this should be the probable fix. There is agg_order in ParseFuncOrColumn, which should get passed on to transformAggregateCall and that should be placed in this call, instead of agg->aggorder. Thanks, Gokul. On Tue, Mar 16, 2010 at 5:19 PM, Gokulakannan Somasundaram < gokul007(a)gmail.com> ... 17 Mar 2010 12:30

[HACKERS] Bug in 9.0Alpha4
Hi, I noticed a problem with the source code of 9.0Alpha 4. In parse_agg.c, there is a call made to transformSortClause. 00098 torder = transformSortClause <http://doxygen.postgresql.org/parse__clause_8c.html#53199c36a198b5acf15a26fbd7311f79>(pstate, 00099 agg->aggorder <... 16 Mar 2010 07:57

[HACKERS] WIP: simple allocator
Hello, this patch significantly reduces memory usage of ispell dictionaries. without patch (Czech dictionary, 64bit linux): cspell: 48816784 total in 5930 blocks; 89496 free (1587 chunks); 48727288 used Ispell dictionary init context: 19226672 total in 12 blocks; 1742624 free (34 chunks); 17484048 used ... 15 Mar 2010 13:29

Ragged latency log data in multi-threaded pgbench
Greg Smith wrote: Just noticed a problem popping up sometimes with the new multi-threaded pgbench. This is on a Linux RPM build (the alpha4 set) compiled with '--disable-thread-safety'. Still trying to nail down whether that's a requirement for this problem to appear or not. I did most of my r... 23 Mar 2010 05:38

[HACKERS] how to use advanced gist options
Hello all, Now I'm trying to realize index in GiST. Everything is Ok, but I would like to know about advanced index programming options. 1) For example - can I delete entry in my picksplit procedure ? 2) Or to add logical conditions - when picksplit node ? For exampe change default "when number of entries of no... 14 Mar 2010 10:54

Getting to beta1
On Fri, 2010-03-12 at 22:28 -0500, Bruce Momjian wrote: Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many on the main 9.0 open items page: http://wiki.postgresql.org/wiki/Po... 18 Mar 2010 16:38

[HACKERS] Getting to beta1
Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many on the main 9.0 open items page: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items#Bugs The list has been reduced greatly in ... 12 Mar 2010 22:53

Reposnse from backend when wrong user/database request send
Tatsuo Ishii <ishii(a)postgresql.org> writes: 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? It's a s... 12 Mar 2010 18:26