Search Discussions
-
I've been doing some benchmarking and profiling on the PostgreSQL query analyzer, and it seems that (at least for the sorts of queries that I typically run) the dominant cost is add_path(). I've been ...
Robert Haas
Feb 1, 2009 at 4:37 am
Feb 28, 2010 at 1:02 am -
Jeff Davis asked me if I'd be willing to do a review of the GIN fast insert patch about two weeks ago, but I haven't actually had a chance to read through it in detail until tonight. I can't say I ...
Robert Haas
Feb 11, 2009 at 2:59 am
Mar 25, 2009 at 12:40 am -
Andrew Gierth was just pointing out to me how badly broken our XPath processing is. For fear of passing an ill formed fragment of xml to the processor, we strip the xml declaration if any and ...
Andrew Dunstan
Feb 26, 2009 at 4:08 am
Mar 20, 2009 at 11:02 pm -
Hi, I need SE-PostgreSQL *ONLY* for row level security, but AFAIK SE-PostgreSQL works only on SELinux. This, for me, is unacceptable, because I want to use row level security on windows too. I don't ...
BogDan Vatra
Feb 10, 2009 at 10:36 am
Feb 18, 2009 at 3:32 pm -
We have an open problem with CVS HEAD that ALTER TABLE SET WITHOUT OIDS causes problems: http://archives.postgresql.org/pgsql-hackers/2008-11/msg00332.php I opined at the time that what we really ...
Tom Lane
Feb 8, 2009 at 4:13 pm
Feb 12, 2009 at 11:57 am -
Hi, Could you please let me know what are the outstanding features that are still to be developed in the respective patches? I'am currently referring the wiki: "Todo and Claim" for NTT and for ...
K, Niranjan (NSN - IN/Bangalore)
Feb 24, 2009 at 6:47 am
Mar 2, 2009 at 2:11 am -
Hi, Right now, when autovacuum is turned on we always assume it's supposed to process all tables except those that have autovacuum_enabled=false. Now, sometimes it might make more sense to keep it ...
Alvaro Herrera
Feb 5, 2009 at 8:52 pm
Feb 10, 2009 at 12:22 am -
Hello some years ago there was some plans about parser's extensibility. I am able write bison extensions, but I thing, so lot of work should be done via hooking of transform stage. I did small ...
Pavel Stehule
Feb 11, 2009 at 10:32 am
Feb 20, 2009 at 2:19 pm -
Hey guys, I had two running threads here: http://archives.postgresql.org/pgsql-general/2009-02/msg00859.php http://www.postgresqlforums.com/forums/viewtopic.php?f=41&t=1574 Both have not come to a ...
Frank Featherlight
Feb 21, 2009 at 1:26 pm
Feb 27, 2009 at 2:50 pm -
Hello, I was helping a customer today with what is becoming a common theme with a lot of work we do. Basically, "It was working fine until recently." Now 90% of the time it is as simple as running an ...
Joshua D. Drake
Feb 13, 2009 at 12:06 am
Feb 21, 2009 at 2:15 am -
After doing some math I've concluded this is in fact the case. Anyone want to check my work? regards, tom lane ----------------------------------- The basic outer-join identities used up through 8.3 ...
Tom Lane
Feb 10, 2009 at 8:10 pm
Feb 20, 2009 at 4:14 pm -
Hi, alvherre@postgresql.org (Alvaro Herrera) wrote: I tested this changes and found two issues: 1. fillfactor.* options are silently ignored when the table doesn't have toast relation. Should we ...
ITAGAKI Takahiro
Feb 10, 2009 at 3:19 am
Feb 11, 2009 at 9:51 pm -
I know we've already had a discussion on the naming of the pg_restore -m option, but in any case this description in pg_restore --help is confusing: -m, --multi-thread=NUM use this many parallel ...
Peter Eisentraut
Feb 12, 2009 at 3:41 pm
Mar 19, 2009 at 9:32 pm -
Hi. Is it in todo or in a plan to implement lmza commpression in pg_dump backups? Thanks Stano -- ------------------------------------------------------------------------ Space Systems *Mgr. Stano ...
Stanislav Lacko
Feb 4, 2009 at 9:49 pm
Feb 8, 2009 at 10:37 pm -
Hadoop backend for PostGreSQL.... A problem that my client has, and one that I come across often, is that a database seems to always be associated with a particular physical machine, a physical ...
Paul Sheer
Feb 21, 2009 at 8:17 pm
Jul 22, 2009 at 3:29 am -
We're using SIGQUIT to signal immediate shutdown request. Upon receiving SIGQUIT, postmaster in turn kills all the child processes with SIGQUIT and exits. This is a problem when child processes use ...
Heikki Linnakangas
Feb 27, 2009 at 9:52 am
Mar 18, 2009 at 9:31 pm -
I have completed all the outstanding pg_migratory TODO items. I still have more work to do in cleanup and testing, but if people want to look at my progress, now is a good time. You can download the ...
Bruce Momjian
Feb 18, 2009 at 2:01 pm
Mar 28, 2009 at 7:18 pm -
I looked into the planning problems in HEAD discussed here: http://archives.postgresql.org/pgsql-hackers/2009-02/msg00120.php As I suspected, there are really two independent bugs there, though both ...
Tom Lane
Feb 5, 2009 at 5:05 pm
Feb 19, 2009 at 10:25 pm -
I would like to add a --freeze parameter to vacuumdb for use by the binary upgrade utility, and for symmetry with the existing VACUUM options; patch attached. I could also accomplish with with ...
Bruce Momjian
Feb 17, 2009 at 4:58 pm
Feb 19, 2009 at 7:13 pm -
Hello, Last week, i took some time to check if i was still able to write some basic C code. So i looked into the TODO list and picked some trivial items. This one is very basic, it just shows the ...
Damien clochard
Feb 25, 2009 at 11:25 pm
Jul 7, 2009 at 7:37 pm -
(back to reviewing the main hot standby patch at last) Why do we need recovery procs? AFAICS the only fields that we use are xid and the subxid cache. Now that we also have the unobserved xids array, ...
Heikki Linnakangas
Feb 24, 2009 at 8:40 am
Feb 26, 2009 at 10:29 am -
CC="xlC_r -q64" \ CXX="xlC_r -q64" \ AR="ar -X64" \ OBJECT_MODE=64 \ PATH=/usr/bin:/usr/vacpp/bin ./configure make Make builds fine, but pg_regress: initdb fails. src/test/regress/log reads: Running ...
Mihai Criveti
Feb 9, 2009 at 2:11 am
Feb 11, 2009 at 8:03 pm -
The pg_autovacuum system catalog will be deprecated in 8.4, but my customers use them to control autovacuum to emulate maintenance window. So, I'm trying to re-implement the catalog using a VIEW and ...
ITAGAKI Takahiro
Feb 16, 2009 at 4:03 am
Mar 9, 2009 at 2:35 pm -
I've been examining multi-major-version binary packaging again, and I was wondering whether we have a good overview over which pieces of the installation are backward compatible (that is, they can be ...
Peter Eisentraut
Feb 12, 2009 at 2:16 pm
Feb 16, 2009 at 11:33 am -
Attached is a patch that modifies psql \dX commands to treat objects in information_schema as "system objects". This prevents them from showing up in \dX *.* and polluting the user objects list. This ...
Martin Pihlak
Feb 25, 2009 at 10:06 am
Apr 8, 2009 at 10:30 pm -
Might that have anything to do with this? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=dungbeetle&dt=2009-02-18%2019:44:01 regards, tom lane
Tom Lane
Feb 18, 2009 at 8:43 pm
Feb 25, 2009 at 10:53 pm -
Hi everyone, I've been recently testing PostgreSQL 8.3.4 (upgrade to 8.3.6 is scheduled) with a large number of connections from separate boxes each using a locally installed pgpool-II set in ...
Matteo Beccati
Feb 11, 2009 at 9:30 am
Feb 14, 2009 at 11:11 am -
Hi, Is there any way to stop autovacuum temporarily?(other than edit postgresql.conf and reload it) Pgpool-II does not want autovacuum running while doing "onlie recovery". -- Tatsuo Ishii SRA OSS, ...
Tatsuo Ishii
Feb 10, 2009 at 1:15 am
Feb 12, 2009 at 10:04 am -
I have thought about how to handle dumped columns and would like to get some feedback on this. It is easy to find the dropped columns with 'pg_attribute.attisdropped = true'. The basic problem is ...
Bruce Momjian
Feb 12, 2009 at 4:30 pm
Feb 17, 2009 at 3:42 pm -
We often discuss changing user-visible behavior of various kinds and are usually clueless on the question of "someone might rely on this" or "how many people are still using this" etc. Still, it is ...
Peter Eisentraut
Feb 11, 2009 at 7:47 am
Feb 12, 2009 at 3:07 am -
Hi, I see a regression test failure in my mingw-vista port when I invoke the command make check MULTIBYTE=euc_jp NO_LOCALE=yes . It causes a crash at tsearch. The crash seems to occur when the server ...
Hiroshi Inoue
Feb 17, 2009 at 11:57 pm
Mar 2, 2009 at 8:43 pm -
Hi, I'm interested in data representation and debug of optimizer routines. Thus, I've changed the debug functions of allpaths.c to make a graphviz-like output of RelOptInfo structure. Any idea about ...
Adriano Lange
Feb 18, 2009 at 3:32 pm
Feb 27, 2009 at 1:06 am -
Hi, When I read function "EvalPlanQual", I found the following code: if (heap_fetch(relation, &SnapshotDirty, &tuple, &buffer, true, NULL)) { /* * If xmin isn't what we're expecting, the slot must ...
Jacky Leng
Feb 19, 2009 at 5:47 am
Feb 20, 2009 at 9:16 am -
When we take the snapshot of running transactions in the master, in GetRunningTransactionData(), it only includes top-level xids and those subxids that are in the subxid caches. Overflowed subxids ...
Heikki Linnakangas
Feb 25, 2009 at 8:40 pm
Mar 4, 2009 at 3:44 am -
Hmm. The comments in vacuum.c about this case suppose that it could only be a transient condition, ie the tuple became dead while we were looking at the page. Evidently it's persistent for you, which ...
Tom Lane
Feb 12, 2009 at 10:13 pm
Feb 25, 2009 at 5:42 pm -
With the new snapshot maintenance code, it looks like we can advance the xmin more aggressively. For instance: S1: INSERT INTO foo VALUES(1); S2: BEGIN; DECLARE c1 CURSOR FOR SELECT i FROM foo; S1: ...
Jeff Davis
Feb 10, 2009 at 8:31 pm
Feb 12, 2009 at 4:40 am -
Hmm, so is this needed on all other PLs too?
Alvaro Herrera
Feb 17, 2009 at 5:14 pm
Mar 8, 2009 at 4:10 pm -
hi, i've been testing new -m option of pg_restore with great pleasure. first, let me thank the developpers, it cut restoring time by half. is it normal that -m doesn't cope well with -C? createdb db ...
Ohp
Feb 18, 2009 at 6:06 pm
Feb 20, 2009 at 1:45 pm -
Hello, I found this today. Note, auto vacuum has been disabled for this relation for a very, very long time. At the very end you will see that this relation has been autovacuumed previously as well. ...
Joshua D. Drake
Feb 13, 2009 at 8:21 pm
Feb 19, 2009 at 4:26 pm -
It would be very useful if there were an option to have ts_headline append ellipses before or after a result fragement based on the position of the fragment in the source document. For instance, when ...
Asher Snyder
Feb 14, 2009 at 8:43 pm
Feb 14, 2009 at 9:55 pm -
One independent change included in the Hot Standby patch is the change to the way subtransaction cache works. With the patch, only subtransactions that don't fit in the subxid cache in PGPROC are ...
Heikki Linnakangas
Feb 12, 2009 at 7:50 am
Feb 13, 2009 at 11:16 am -
Here is my problem and also the question. I'd like adding a field in Path structure and Plan structure as follows: typedef struct Path{ ....bla bla bla Cost energy_cost; ....bla bla bla } typedef ...
Zichen Xu
Feb 23, 2009 at 9:14 pm
Feb 24, 2009 at 1:31 pm -
Hi everyone, I want to try to add a multi calendar system for pgsql. I want to know if it will be accepted as a patch to pgsql? More details: Multi calendar systems are useful for several languages ...
Mohsen Alimomeni
Feb 18, 2009 at 4:21 pm
Feb 22, 2009 at 2:22 pm -
I reported the following bug to -bugs, and I'd like to discuss whether we need to fix the issue or how to fix it. "ITAGAKI Takahiro" wrote: We already have some codes to avoid -0 float8um (unary ...
ITAGAKI Takahiro
Feb 17, 2009 at 1:13 am
Feb 18, 2009 at 1:35 am -
If Kerberos V5 is not installed on a Windows platform, the following error dialog is returned upon attempted installation: Posgres.exe - Unable to Locate Component This application has failed to ...
Dann Corbit
Feb 27, 2009 at 1:32 am
Feb 27, 2009 at 11:16 am -
Should we log a warning at startup when effective_cache_size is less than shared_buffers? -Kevin
Kevin Grittner
Feb 25, 2009 at 11:21 pm
Feb 26, 2009 at 9:43 am -
... and the build logs don't show any particular reason for it. What is wrong, and why isn't the buildfarm script capturing a useful error message? regards, tom lane
Tom Lane
Feb 25, 2009 at 4:41 pm
Feb 25, 2009 at 5:42 pm -
Hello I am checking this functionality and I am afraid, so option all is broken. postgres=# select * from pg_stat_user_functions; funcid | schemaname ...
Pavel Stehule
Feb 22, 2009 at 2:27 pm
Feb 22, 2009 at 11:51 pm -
Howdy, I was just updating a function in pgTAP that, given a schema name and an array of function names, returns a set of those function names that are not in the named schema. I got it working with ...
David E. Wheeler
Feb 20, 2009 at 1:13 am
Feb 20, 2009 at 4:09 am -
Hmm, I suppose we can't readily run pg_dump against a stand-alone backend? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Heikki Linnakangas
Feb 10, 2009 at 4:52 pm
Feb 10, 2009 at 5:22 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 110 |
posts | 1,399 |
users | 128 |
website | postgresql.org... |
irc | #postgresql |
128 users for February 2009
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)