PgSql

[HACKERS] NEED HELP !
Hello all, I am a student-magister and I'm writting my magister work. I realized gist index TPR tree - it is like a simple R tree but moving :) Everything is compiling ok, I creating table and index, but after whese code - DB is restarting :((( * * *set enable_seqscan = false select * from table_of_moving_obj... 13 Jan 2010 14:20

[HACKERS] Hot Standby and query cancel
We've been chewing around query cancel on Hot Standby and I think things have got fairly confusing, hence a new thread. I enclose a patch that includes all the things that we all agree on so far, in my understanding * Recovery conflict processing uses SIGUSR1 rather than shmem per Tom, while holding ProcArray... 13 Jan 2010 14:20

Incrementally Updated Backups and restartpoints
On Wed, Jan 13, 2010 at 8:36 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Our documentation suggests that you can take a base backup of a warm standby server while it's running: If we take a backup of the standby server's data directory while it is processing logs shipped from the p... 13 Jan 2010 18:54

[HACKERS] Deadlock in vacuum (check fails)
I found following strange error on gothic moth: ================== pgsql.22658/src/test/regress/regression.diffs =================== *** /zfs_data/home/postgres/buildfarm/gothic_moth/HEAD/pgsql.22658/src/test/regress/expected/vacuum.out Tue Jan 12 22:06:13 2010 --- /zfs_data/home/postgres/buildfarm/gothi... 13 Jan 2010 05:26

lock_timeout GUC patch
Jaime Casanova <jcasanov(a)systemguards.com.ec> writes: it has a hunk failed when trying to apply i guess it's because of Tom's refactor of relcache.c If this patch is touching those parts of relcache.c, it probably needs rethinking. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hac... 19 Feb 2010 17:45

plpython3
On Sun, Dec 13, 2009 at 5:02 PM, James Pye <lists(a)jwp.name> wrote: On Nov 19, 2009, at 5:41 PM, James Pye wrote: Here's my latest patch. Fixed a lot of memory/reference leaks, added some minor features(mostly around Arrays), and filled in more documentation. At this point, I don't have any more minor... 2 Feb 2010 16:10

[HACKERS] xml2 still essential for us
Reporting as requested, there are two things our projects continue to need xml2 for, and a third which we conceptually need xml2 for: (1) We need some way to do xslt processing. (2) We need the equivalent of xml_is_well_formed(text), e.g. a documented way to call XMLPARSE speculatively and get a NULL or be ab... 12 Jan 2010 21:53

Any ExecStoreTuple end runs?
"Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> writes: Hopefully this won't digress into a top-to-bottom discussion of all aspects of implementing serializable transactions again, but I have what I hope is a quick question. The "easy" part of implementing SIREAD level predicate locking should be to ge... 12 Jan 2010 19:41

[HACKERS] Any ExecStoreTuple end runs?
Hopefully this won't digress into a top-to-bottom discussion of all aspects of implementing serializable transactions again, but I have what I hope is a quick question. The "easy" part of implementing SIREAD level predicate locking should be to get a lock on each visible tuple which is read in the execution of ... 12 Jan 2010 18:34

Clearing global statistics
Magnus Hagander wrote: I have on my TODO to implement the ability to do stats reset on a single object (say, one table only). Please take this into consideration when you design/name this, so theres no unnecessary overlap :-) Same goes for the stats message itself. The idea suggested upthread was t... 19 Jan 2010 10:09