Search Discussions
-
I think what he is looking for is a table that is maintained in CLUSTERed order... ie. new inserts will be put in the appropriate place mimicing what happens with indexes. This has been discussed in ...
Robert Treat
May 1, 2005 at 1:34 am
May 6, 2005 at 3:28 pm -
101
pgFoundry
Hello, PgFoundry has been brought up quite a bit lately. How we want it to succeed, how we want it to be the hub of PostgreSQL development. So my question is... Why isn't it? Why is PostgreSQL not ...Joshua D. Drake
May 6, 2005 at 3:32 am
Jun 9, 2005 at 5:55 am -
Recent test results have shown a substantial performance improvement (+25%) if WAL logging is disabled for large COPY statements. This is to be expected, though has a price attached: losing the ...
Simon Riggs
May 31, 2005 at 11:06 pm
Jun 3, 2005 at 10:15 pm -
PG hackers, AndrewSN, Jim Nasby, Elein and I have been working for the last couple of months on a new set of system views for PostgreSQL. (primarily Andrew, who did the lion's share of the work and ...
Josh Berkus
May 5, 2005 at 4:37 am
May 15, 2005 at 7:25 pm -
Oracle Style packages on postgres OVERVIEW: To emulate oracle server side development in postgres I required server side packages. The following text demonstrates how to do this using plpython on ...
Rmm
May 7, 2005 at 11:01 am
Jun 1, 2005 at 12:58 pm -
since to Not useless at all, I couldn't' agree with you more. In fact, there is a good security argument to be made here as well. In the current state of things, a user with no rights at all can see ...
Merlin Moncure
May 10, 2005 at 3:21 pm
May 14, 2005 at 2:07 pm -
Small tarball size isn't the *primary* reason for having our "push-it-out-to-pgFoundry" attitude, it's the *tertiary* reason. The main two reasons are: 1) If we start including everything that's ...
Josh Berkus
May 4, 2005 at 1:05 am
May 5, 2005 at 1:43 am -
Is there a good reason that pl/pgsql is not installed in databases by default? I think it should be. pl/pgsql is widely used, and having it installed by default would be one less hurdle for newbies ...
Neil Conway
May 6, 2005 at 4:59 am
May 9, 2005 at 5:32 am -
Hello, I've been using Postgresql-8.0.1 (Release date: 2005-01-31) for my research work and I guess I finally need some help with it... I'm not trying to modify the existing functionality, but I want ...
Vikram Kalsi
May 25, 2005 at 6:50 pm
Jun 6, 2005 at 1:35 am -
There's still a lengthy discussion going on whether it's a good idea to add a forth way to read pgsql's schema (pg_* tables, pg_* views, information_schema, did I miss one?), but I'd like to see ...
Andreas Pflug
May 11, 2005 at 4:44 pm
May 14, 2005 at 3:47 pm -
I thought about that, but adding additional escape letters isn't our problem --- it is the escape mechanism itself that is the issue. I have wanted to post on this issue so now is a good time. I ...
Bruce Momjian
May 29, 2005 at 3:58 am
Jun 2, 2005 at 3:55 am -
Folks, Hey, I can see a way for /contrib to become a lot better option for stuff-we're-not-sure-whether-to-include. What if we could build contrib modules through a build-time switch for PostgreSQL? ...
Josh Berkus
May 11, 2005 at 9:24 pm
May 12, 2005 at 5:02 pm -
I've started to look seriously at Heikki's patch for two-phase commit. There are a few issues that probably deserve discussion: * The major missing issue that I've come across so far is that ...
Tom Lane
May 18, 2005 at 9:15 pm
Jun 11, 2005 at 5:54 pm -
Dave, Hmmm ... why does everyone assume that Core does more than what we do? I think that most people would be surprised by how *little* traffic there is on the pgsql-core mailing list. Core decides ...
Josh Berkus
May 2, 2005 at 6:15 pm
May 5, 2005 at 1:42 am -
Greetings. I have questions on how to implement on-disk bitmap scan. I've been working on on-disk bitmaps as an ordinary Index Access Method, but now it's clear to me, that it'll lose all it's ...
Victor Y. Yegorov
May 12, 2005 at 7:21 pm
Jun 14, 2005 at 10:05 am -
It seems we are more or less agreed that 32-bit CRC ought to be enough for WAL; and we also need to make a change to ensure that backup blocks are positively linked to their parent WAL record, as I ...
Tom Lane
May 31, 2005 at 8:26 pm
Jul 12, 2005 at 9:17 pm -
The other issue is 'what XML format'? Find me a standard data dump XML DTD and I'll change phpPgAdmin to use it as well. Otherwise, phpPgAdmin's is quite simple. Chris
Christopher Kings-Lynne
May 12, 2005 at 2:35 am
May 28, 2005 at 4:12 am -
About this time last year I was holding forth on the value of visiting the heap in TID order, even when index scan tuples are randomly ordered. Today I decided to start working on the problem stated ...
Jeffrey W. Baker
May 16, 2005 at 4:24 am
May 19, 2005 at 11:56 am -
The SQL_ASCII-breaks-JDBC issue just came up yet again on the JDBC list, and I'm wondering if we can do something better on the server side to help solve it. The problem is that people have SQL_ASCII ...
Oliver Jowett
May 12, 2005 at 2:42 am
May 13, 2005 at 10:32 pm -
This seems perfectly ok...as long as there is 1:1 correspondence between locktag and lock for all present and future types of locks. I'd like to point out though that when querying for user locks ...
Merlin Moncure
May 2, 2005 at 2:58 pm
May 4, 2005 at 2:11 pm -
ERROR: source database "template1" is being accessed by other users Why is this not allowed? Not that there is generally a reason to be in template1, but am curious as to why it prevents a new DB ...
Marc G. Fournier
May 31, 2005 at 6:03 pm
Jun 1, 2005 at 12:38 pm -
I spent a little while looking into a performance issue with a large UPDATE on a table with foreign keys. A few questions: (1) When a PK table is updated, we skip firing the per-row UPDATE RI ...
Neil Conway
May 26, 2005 at 7:56 am
May 27, 2005 at 3:09 pm -
Just want to make sure that this is, in fact, what is expected: client1: begin; client1: update articles set some_col = <foo where id = <bar ; client2: update articles set some_col2 = <foo2 where id ...
Marc G. Fournier
May 31, 2005 at 5:45 pm
Jun 1, 2005 at 1:36 pm -
I promised an analysis of the problems Jan Wieck uncovered yesterday, so here it is. Jan had developed a testbed (which I hope he will post) that essentially has a bunch of client threads all doing ...
Tom Lane
May 7, 2005 at 5:36 pm
Aug 17, 2005 at 3:53 am -
I was doing some profiles recently that showed that on simple statements (like INSERT with a few column values) the basic parser (flex/bison) was taking up a noticeable percentage of the total CPU ...
Tom Lane
May 23, 2005 at 4:31 pm
Jun 6, 2005 at 8:49 am -
Currently PG win32 port mainly does the following to simulate signals: (*) the process who kill the signal: - put the signal in a named pipe, then it is done; (*) the process who should receive the ...
Qingqing Zhou
May 26, 2005 at 6:01 am
Jun 2, 2005 at 2:09 am -
Hello all, We would like to contribute to the Postgresql community by implementing the following items from the TODO list (http://developer.postgresql.org/todo.php): . Allow COPY to understand \x as ...
Sergey Ten
May 12, 2005 at 2:01 am
May 18, 2005 at 5:09 pm -
Maybe we should take a different approach to the problem: 1. Create new file with an extension to mark that it's not yet committed (eg. 1234.notcommitted) 2. ... 3. Take CheckpointStartLock 4. Write ...
Heikki Linnakangas
May 7, 2005 at 6:52 pm
May 11, 2005 at 1:19 pm -
Many people have been discussing Table Partitioning lately. I've also been giving thought to how to implement Table Partitioning within PostgreSQL, as part of the Bizgres project for Business ...
Simon Riggs
May 9, 2005 at 9:06 pm
May 11, 2005 at 10:04 am -
We've seen two recent reports: http://archives.postgresql.org/pgsql-admin/2005-04/msg00008.php http://archives.postgresql.org/pgsql-general/2005-05/msg01143.php of postmaster restart failing because ...
Tom Lane
May 25, 2005 at 3:02 pm
May 27, 2005 at 3:59 pm -
I've been working on adding the functionality into the jdbc driver and I'm having some issues. Currently the bind message does not know anything about directionality of the parameter. This means that ...
Dave Cramer
May 24, 2005 at 6:14 pm
May 25, 2005 at 12:04 pm -
I have a customer with the following error. rpm -Uvh *.rpm warning: postgresql-8.0.2-1PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e error: Failed dependencies: libpq.so.3 is needed by ...
Dave Cramer
May 19, 2005 at 12:12 pm
May 20, 2005 at 7:47 pm -
I'm not sure whether this article has been mentioned here before, but it definitely is worth a read: http://www.usenix.org/events/fast03/tech/full_papers/anderson/anderson_html/ From the proceedings ...
Tom Lane
May 31, 2005 at 4:07 am
Jun 1, 2005 at 7:40 pm -
There has been discussion in the past of including number of days as part of the Interval structure in addition to the current months and time components. Here are some mailing list threads where the ...
Michael Glaesemann
May 30, 2005 at 2:06 pm
Jun 1, 2005 at 2:31 pm -
Should we not change it to bonjour as that is the actual name for it? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, ...
Joshua D. Drake
May 6, 2005 at 9:59 pm
May 27, 2005 at 3:28 pm -
How come we don't set SO_KEEPALIVE in libpq? Is there any reason why we wouldn't want it on? -- /Dennis Björklund
Dennis Bjorklund
May 16, 2005 at 3:03 pm
May 22, 2005 at 8:15 pm -
I meant to mention this during previous discussion. Currently the pg_regress script does "dbname=regression" and then does everything in terms of $dbname. Would there be any value in providing a ...
Andrew Dunstan
May 14, 2005 at 9:48 pm
May 17, 2005 at 6:27 pm -
We have developed patches which relaxes the character validation so that PostgreSQL accepts invalid characters. It works like this: 1) new postgresql.conf item "mbstr_check" added. 2) if mbstr_check ...
Tatsuo Ishii
May 8, 2005 at 2:01 am
May 9, 2005 at 3:37 am -
-- First part --- In md.c/RememberFsyncRequest(): if (hash_search(pendingOpsTable, &entry, HASH_ENTER, NULL) == NULL) ereport(FATAL, (errcode(ERRCODE_OUT_OF_MEMORY), errmsg("out of memory"))); ...
Qingqing Zhou
May 27, 2005 at 3:29 am
Jun 9, 2005 at 5:20 am -
Hackers, I'm seeing the following weirdness with the 2PC patch: alvherre=# begin; BEGIN alvherre=# create table a (a int); CREATE TABLE alvherre=# insert into a values (1); INSERT 0 1 alvherre=# ...
Alvaro Herrera
May 26, 2005 at 11:27 pm
May 31, 2005 at 3:19 pm -
For the past couple of releases we've had support for cstring (null-terminated string) as a full fledged datatype: you set typlen = -2 to indicate that strlen() must be used to calculate the actual ...
Tom Lane
May 29, 2005 at 3:47 pm
May 30, 2005 at 1:13 am -
Hey everyone, I've been working with a couple people who didn't know that soundex and metaphone were included in the distribution as contrib modules. While it's their fault that they didn't check ...
Jonah H. Harris
May 24, 2005 at 9:12 pm
May 27, 2005 at 6:46 am -
Hi, I was redirected to this maillist when i asked questions on irc. I hope this is the right mailing list. I am running postgresql 7.4.8 on solaris 10 (and I compile and installed slony). Everytime ...
Junaili Lie
May 24, 2005 at 6:39 pm
May 26, 2005 at 6:11 pm -
Hackers, I was reading LWN.net and noticed an article about Eben Moglen's keynote at linux.conf.au. Apparently he advises free software projects to get patents on their best ideas. Eben encouraged ...
Alvaro Herrera
May 8, 2005 at 5:13 am
May 11, 2005 at 10:02 pm -
Are there any regression tests or unit tests beyond 'make check', or possibly benchmarks which not only measure performance but also verify that the results are correct? I have patches which I want ...
Dag-Erling Smørgrav
May 3, 2005 at 1:00 pm
May 4, 2005 at 3:46 pm -
In 8.0, PostgreSQL lost its previously postulated ability to be cross-compiled and it turns out some people actually used that, so here's an attempt to fix it. The problem is that the program zic in ...
Peter Eisentraut
May 30, 2005 at 5:36 pm
Jul 3, 2005 at 6:58 pm -
OK, now I finally get the point: you are creating child tables in different schemas than their parents live in. This creates a problem because reverse-listing of the constraints varies depending on ...
Tom Lane
May 20, 2005 at 3:27 am
May 30, 2005 at 9:08 pm -
I tried disabling public EXECUTE access on the built-in conversion functions, as we recommended yesterday, and found that it has one small problem: the conversion regression test fails. The test is ...
Tom Lane
May 3, 2005 at 5:14 pm
May 4, 2005 at 4:49 am -
Hi, here we go again... As you know there is a problem executing something like: create table foo ( col1 serial, col2 int ); create view v_foo as select * from foo; create rule ins_rule as on insert ...
Jaime Casanova
May 28, 2005 at 1:25 pm
Jun 6, 2005 at 2:44 pm -
Has anyone tried to compile postgres with Visual Age compiler on OpenPower5 (IBM-ese for linux only PowerPC based server) either 32 or 64 bit ? We got it to build fine on both Suse and RHAS, but have ...
Hannu Krosing
May 29, 2005 at 2:20 pm
May 30, 2005 at 10:01 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 152 |
posts | 1,590 |
users | 158 |
website | postgresql.org... |
irc | #postgresql |
158 users for May 2005
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)