Search Discussions
-
We all know that PostgreSQL suffers performance problems when rows are updated frequently prior to a vacuum. The most serious example can be seen by using PostgreSQL as a session handler for a busy ...
Mark L. Woodward
Jun 21, 2006 at 5:53 pm
Jun 29, 2006 at 3:27 pm -
Just got this rather surprising result: regression=# \timing Timing is on. regression=# explain analyze select * from tenk1 a join tenk1 b on a.unique1 = b.unique2; QUERY PLAN ...
Tom Lane
Jun 6, 2006 at 3:02 am
Jun 13, 2006 at 5:37 pm -
I've implemented most of ADD/DROP INHERITS but it's my first significant piece of code at this level. I would appreciate any feedback about it. In particular I'm worried I may be on the wrong track ...
Greg Stark
Jun 7, 2006 at 5:33 pm
Jun 11, 2006 at 5:23 pm -
[ redirecting to -hackers, as I see no need for this to be a core issue ] Charles Comiskey <comiskey@us.ibm.com writes: This code seems to have been inserted by Tom Lockhart on 1997-07-29 (geo_ops.c ...
Tom Lane
Jun 22, 2006 at 3:37 pm
Jun 26, 2006 at 5:43 pm -
Ah, OK that makes sense. An alternative solution when the signature was changed could perhaps have been to pass one single argument, a structure appointing the data and its associated type. My idea ...
Thomas Hallgren
Jun 28, 2006 at 4:39 pm
Jul 9, 2006 at 1:35 pm -
Something someone said on IRC just now triggered a little memory ... I think we should provide an option to have pg_dump work in CSV mode rather than text mode. This probably doesn't have much ...
Andrew Dunstan
Jun 12, 2006 at 5:13 pm
Jun 14, 2006 at 10:27 pm -
I've been making another pass over getting rid of buildfarm failures. The remaining ones I see at the moment are: firefly HEAD: intermittent failures in the stats test. We seem to have fixed every ...
Tom Lane
Jun 2, 2006 at 4:07 am
Aug 19, 2006 at 10:58 am -
The only way that I'm aware of for disabling this is at compile time ... after running configure, you want to modify: src/include/pg_config.h and undef HAVE_SETPROCTITLE ... I'm CC'ng -hackers about ...
Marc G. Fournier
Jun 11, 2006 at 9:34 pm
Jun 17, 2006 at 5:57 pm -
We have now experienced index corruption on two separate but identical slony clusters. In each case the slony subscriber failed after attempting to insert a duplicate record. In each case reindexing ...
Marc Munro
Jun 28, 2006 at 4:28 pm
Jul 20, 2006 at 12:47 am -
Tom had posted a question about file compression with copy. I thought about it, and I want to through this out and see if anyone things it is a good idea. Currently, the COPY command only copies a ...
Mark L. Woodward
Jun 2, 2006 at 1:26 pm
Jun 6, 2006 at 2:56 pm -
OK, here's my problem, I have a nature study where we have about 10 video cameras taking 15 frames per second. For each frame we make a few transactions on a PostgreSQL database. We want to keep ...
Mark L. Woodward
Jun 6, 2006 at 12:28 pm
Jun 11, 2006 at 8:36 pm -
O.k. so now what I am getting from this thread is, the functions exist now in pg_dump but we want to pull them out of pg_dump and push them into the backend? Joshua D. Drake -- === The PostgreSQL ...
Joshua D. Drake
Jun 10, 2006 at 11:09 pm
Aug 22, 2006 at 3:40 am -
I am thrill to inform you all that Sun has just donated a fully loaded T2000 system to the PostgreSQL community, and it's being setup by Corey Shields at OSL (osuosl.org) and should be online ...
Robert Lor
Jun 16, 2006 at 3:22 pm
Jul 24, 2006 at 3:35 am -
I notice buildfarm member snake is unhappy: The program "postgres" is needed by initdb but was not found in the same directory as ...
Tom Lane
Jun 19, 2006 at 11:02 pm
Jun 23, 2006 at 7:29 am -
meerkat and snake both have persistent "CVS-Unknown" failures in some but not all branches. I can't see any evidence of an actual failure in their logs though. What I do see is "?" entries about ...
Tom Lane
Jun 1, 2006 at 10:34 pm
Jun 5, 2006 at 2:17 pm -
I redid my previous measurements after finishing up the weekend's hacking. The numbers shown below are elapsed time in seconds for time psql -f testfile.sql postgres /dev/null using CVS HEAD and ...
Tom Lane
Jun 21, 2006 at 3:02 pm
Jun 26, 2006 at 7:47 pm -
While investigating some problems with buildfarm member spoonbill I came across this piece of code in pg_regress.sh, which seems less than robust: # Wait till postmaster is able to accept connections ...
Andrew Dunstan
Jun 18, 2006 at 9:31 pm
Jun 19, 2006 at 2:49 pm -
I am working on a possible extension of postgresql mvcc to support very timely failure masking in the context of three-tier applications so i am currently studying Postgresql internals... I am ...
Paolo romano
Jun 16, 2006 at 11:35 pm
Jun 19, 2006 at 8:40 am -
Would some people please run the attached test procedure and report back the results? I basically need to know the patch is an improvement on more platforms than just my own. Thanks ...
Bruce Momjian
Jun 15, 2006 at 4:05 am
Jun 17, 2006 at 5:43 pm -
In view of my oprofile results http://archives.postgresql.org/pgsql-hackers/2006-06/msg00859.php I'm thinking we need some major surgery on the way that the stats collection mechanism works. It ...
Tom Lane
Jun 17, 2006 at 9:12 pm
Jun 19, 2006 at 2:29 pm -
I've been interested in representing and manipulating time ranges in PostgreSQL, where a time range is defined by a start time and an end time. Time ranges are useful, for example, in representing ...
Michael Glaesemann
Jun 10, 2006 at 2:52 pm
Jun 16, 2006 at 4:37 pm -
Hi, I see a performance issue on win32. This problem is causes by the following URL. http://support.microsoft.com/kb/823764/EN-US/ On win32, default SO_SNDBUF value is 8192 bytes. And libpq's buffer ...
Yoshiyuki Asaba
Jun 27, 2006 at 3:23 pm
Jun 28, 2006 at 3:59 pm -
Motivation: ---------- The main goal for this Generic Monitoring Framework is to provide a common interface for adding instrumentation points or probes to Postgres so its behavior can be easily ...
Robert Lor
Jun 19, 2006 at 8:01 pm
Jun 20, 2006 at 5:48 pm -
Hey, I just noticed (the hard way) that in 8.2CVS, the PG_MODULE_MAGIC header is now *required* for all loadable modules. This includes non-pg modules, such as Solaris' libumem (performance ...
Josh Berkus
Jun 14, 2006 at 11:54 pm
Jun 16, 2006 at 2:23 pm -
Moving to -hackers I've been able to verify this on 8.1.4; psql -A -t -c 'SELECT * FROM largetable' /dev/null results in psql consuming vast quantities of memory. Why is this? ISTM this is a bug... ...
Jim C. Nasby
Jun 5, 2006 at 3:23 pm
Jun 6, 2006 at 2:47 pm -
[ moving to -hackers to get some more eyeballs on the question ] Simon Riggs <simon@2ndquadrant.com writes: No, which is a tad annoying now that you mention it. I'm not sure that there's any very ...
Tom Lane
Jun 12, 2006 at 11:15 pm
Jun 27, 2006 at 1:58 pm -
I'm developing the summer of code project to create a xlog viewer. The tool we want to create is a DBA tool used for inspect the xlog files, looking for some operations, statistcs of database usage ...
Diogo Biazus
Jun 22, 2006 at 12:02 pm
Jun 25, 2006 at 11:19 pm -
As I follow Relyea Mike's recent post of possible memory leak, I think that we are lack of a good way of identifing memory usage. Maybe we should also remember __FILE__, __LINE__ etc for better ...
Qingqing Zhou
Jun 20, 2006 at 1:57 am
Jun 23, 2006 at 2:30 am -
http://lwn.net/Articles/178199/ Check out the article on sync_file_range(): ---- long sync_file_range(int fd, loff_t offset, loff_t nbytes, int flags); This call will synchronize a file's data to ...
Christopher Kings-Lynne
Jun 19, 2006 at 5:42 am
Jun 20, 2006 at 2:22 pm -
Here is an overview of the SITC method: http://momjian.us/cgi-bin/pgsitc Anyone want to start coding? -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a ...
Bruce Momjian
Jun 28, 2006 at 6:16 pm
Jun 30, 2006 at 2:36 am -
While looking at the recently-noticed problem that HashAggregate nodes store more columns of the input than they need to, I couldn't help noticing how much of the hashtable space goes into HeapTuple ...
Tom Lane
Jun 26, 2006 at 2:36 pm
Jun 26, 2006 at 9:08 pm -
+1 -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat
Jun 8, 2006 at 12:22 am
Jun 8, 2006 at 7:35 pm -
Sorry, but I thought it that was the most appropriate list for the issue. I was following these instructions: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html And what ...
Rodrigo Hjort
Jun 2, 2006 at 6:35 pm
Jun 8, 2006 at 10:42 am -
on IRC somebody mentioned that it took 34h to greate a GIN index (on a tsvector) on a ~3 Million column table (wikipedia dump) with a reasonable speced box (AMD 3400+). After getting hold of a dump ...
Stefan Kaltenbrunner
Jun 26, 2006 at 5:09 pm
Jul 11, 2006 at 8:26 pm -
I have an optimization I'd like to see which I think should be pretty easy for someone familiar with the planner code to implement. My situation is this: I have an application using veil[1]. ...
Phil Frost
Jun 28, 2006 at 2:56 pm
Jul 2, 2006 at 12:48 am -
Buildfarm member platypus is showing a regression failure that I'm surprised we have not seen before: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-06-28%2014:05:01 Basically ...
Tom Lane
Jun 28, 2006 at 4:09 pm
Jun 28, 2006 at 11:38 pm -
This has come up before, but I was reminded of it again after noticing how confused psql gets if you use control-C to get out of a long "\lo_import" operation. Usually the control-C hits while ...
Tom Lane
Jun 11, 2006 at 4:32 pm
Jun 13, 2006 at 8:31 am -
There is a well known command called CLUSTER which organizes table in specified index's order. It has a drawback, that new tuples added are not in this order. Last night I had idea which could be ...
Dawid Kuroczko
Jun 25, 2006 at 11:48 pm
Jun 28, 2006 at 3:46 am -
Hi, I think there is a bug/misscalculation of some rare query i am using. Suppose we only query one specific relation R. R contains indices but not on all attributes or not on all ordered subset of ...
Tzahi Fadida
Jun 23, 2006 at 12:56 pm
Jun 23, 2006 at 9:13 pm -
Hi, after some experimentation, I came up with the attached patch, which implements parsing the following SERIAL types: SERIAL SERIAL GENERATED { ALWAYS | BY DEFAULT } SERIAL GENERATED [ ALWAYS | BY ...
Zoltan Boszormenyi
Jun 11, 2006 at 10:39 pm
Jun 12, 2006 at 9:59 pm -
On a separate note. The one major remaining piece here is in constraints. I'm thinking what I have to check is that every constraint present on the parent table is present on the child tables. And ...
Greg Stark
Jun 8, 2006 at 8:30 pm
Jun 9, 2006 at 6:50 pm -
I originally suggested a methodology for preserving MVCC and everyone is confusing it as update "in place," this isnot what I intended. How about a form of vacuum that targets a particular row? Is ...
Mark L. Woodward
Jun 24, 2006 at 6:11 pm
Jun 26, 2006 at 6:50 pm -
Lines 509-512 of contrib/dblink/expected/dblink.out read: -- this should fail because there is no open transaction SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo'); ...
Tom Lane
Jun 18, 2006 at 3:35 pm
Jun 20, 2006 at 9:00 pm -
SELECT INTO doesn't set ROW_COUNT ... but if we change the code to set FOUND before throwing the error, it'd work to tell people to check FOUND. (Thinks a bit...) Actually not, because if the ...
Tom Lane
Jun 16, 2006 at 8:06 pm
Jun 16, 2006 at 11:02 pm -
I looked into the timezone specifications and basically extracted a list of existing offsets from the zic database. My proposed format for the timezone files is something like this: HADT -32400 D # ...
Joachim Wieland
Jun 13, 2006 at 12:20 pm
Jun 14, 2006 at 9:40 pm -
We got a lot requests about including stemmers and ispell dictionaries for all accessible languages into tsearch2. I understand that tsearch2 will be closer to end user. But sources of snowball ...
Teodor Sigaev
Jun 7, 2006 at 5:06 pm
Jun 9, 2006 at 2:27 pm -
Can someone please explain why in include/utils/datetime.h (struct datetkn) there is a check for _AIX that either initializes a char* pointer or a char array? Is there any advantage of a char-array ...
Joachim Wieland
Jun 6, 2006 at 10:33 am
Jun 7, 2006 at 1:41 am -
A bug reported by Josh Drake, crashes 8.1 and CVS HEAD: Test case is: create table pk (id bigserial primary key); insert into pk values (DEFAULT); insert into pk values (DEFAULT); insert into pk ...
Alvaro Herrera
Jun 20, 2006 at 4:53 pm
Jun 21, 2006 at 6:44 pm -
Awhile back, there was a discussion about psql \d display being really slow in a database with 4000 tables: http://archives.postgresql.org/pgsql-hackers/2005-09/msg01085.php I looked into this some, ...
Tom Lane
Jun 14, 2006 at 11:25 pm
Jun 15, 2006 at 1:32 pm -
Currently, the only way to get a listing of tables in a schema via psql is to modify your search_path, which is both non-intuitive and a PITA. You can do \d schemaname., but that's the equivalent of ...
Jim C. Nasby
Jun 9, 2006 at 7:34 pm
Jun 9, 2006 at 9:08 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 150 |
posts | 1,624 |
users | 147 |
website | postgresql.org... |
irc | #postgresql |
147 users for June 2006
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)