Search Discussions

152 discussions - 1,590 posts

  • 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 TreatRobert Treat
    May 1, 2005 at 1:34 am
    May 6, 2005 at 3:28 pm
  • 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. DrakeJoshua 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 RiggsSimon 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 BerkusJosh 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 ...
    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 MoncureMerlin 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 BerkusJosh 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 ConwayNeil 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 KalsiVikram 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 PflugAndreas 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 MomjianBruce 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 BerkusJosh 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 LaneTom 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 BerkusJosh 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. YegorovVictor 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 LaneTom 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-LynneChristopher 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. BakerJeffrey 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 JowettOliver 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 MoncureMerlin 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. FournierMarc 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 ConwayNeil 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. FournierMarc 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 LaneTom 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 LaneTom 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 ZhouQingqing 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 TenSergey 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 LinnakangasHeikki 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 RiggsSimon 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 LaneTom 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 CramerDave 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 CramerDave 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 LaneTom 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 GlaesemannMichael 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. DrakeJoshua 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 BjorklundDennis 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 DunstanAndrew 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 IshiiTatsuo 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 ZhouQingqing 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 HerreraAlvaro 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 LaneTom 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. HarrisJonah 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 LieJunaili 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 HerreraAlvaro 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ørgravDag-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 EisentrautPeter 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 LaneTom 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 LaneTom 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 CasanovaJaime 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 KrosingHannu Krosing
    May 29, 2005 at 2:20 pm
    May 30, 2005 at 10:01 am
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
grouppgsql-hackers @

158 users for May 2005

Tom Lane: 269 posts Bruce Momjian: 101 posts Josh Berkus: 86 posts Marc G. Fournier: 82 posts Andrew Dunstan: 60 posts Joshua D. Drake: 50 posts Jim C. Nasby: 39 posts Christopher Kings-Lynne: 38 posts John Hansen: 38 posts Neil Conway: 37 posts Alvaro Herrera: 31 posts Simon Riggs: 29 posts Andrew - Supernews: 28 posts Greg Stark: 27 posts Hannu Krosing: 27 posts Peter Eisentraut: 26 posts Robert Treat: 25 posts Magnus Hagander: 22 posts Stephen Frost: 21 posts Thomas Hallgren: 18 posts
show more