FAQ

PostgreSQL > pgsql-hackers > September 2001

Search Discussions

188 discussions - 895 posts

  • At the just-past OSDN database conference, Bruce and I were annoyed by some benchmark results showing that Postgres performed poorly on an 8-way SMP machine. Based on past discussion, it seems likely ...
    Tom LaneTom Lane
    Sep 26, 2001 at 4:10 pm
    Oct 1, 2001 at 9:58 pm
  • Since there have been drastic CVS changes, the web page doc should REALLY be updated... http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html - Brandon ...
    BpalmerBpalmer
    Sep 23, 2001 at 5:36 pm
    Oct 4, 2001 at 4:09 pm
  • Hi all, while working on a new project involving PostgreSQL and making some tests, I have come up with the following output from psql : lang | length | length | text | text ...
    Patrice HédéPatrice Hédé
    Sep 24, 2001 at 9:52 pm
    Oct 15, 2001 at 1:26 am
  • How hard would it be to pre-fork an extra backend for the database a user just requested so if they next user asks for the same database, the backend would already be started? -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Sep 29, 2001 at 6:22 pm
    Oct 29, 2001 at 3:54 am
  • This will most likely screw some ppl up, and fix others ... CVSROOT has now moved to the new machine, finally ... and I've cleaned up pathing ... and CVS_RSH=ssh now works again too ... So, now ...
    Marc G. FournierMarc G. Fournier
    Sep 16, 2001 at 5:05 pm
    Sep 21, 2001 at 12:21 pm
  • Hi all, Attached is a patch that adds support for specifying a location for indexes via the "create database" command. I believe this patch is complete, but it is my first . Thanks Jim
    Jim ButtafuocoJim Buttafuoco
    Sep 11, 2001 at 6:23 pm
    Sep 12, 2001 at 8:58 pm
  • Is the schedule still to go beta Monday? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your ...
    Bruce MomjianBruce Momjian
    Sep 7, 2001 at 4:32 am
    Sep 8, 2001 at 12:51 am
  • I have just noticed a flaw in the handling of "-o backend-options" postmaster parameters. To wit: although these options will be passed to all backends launched by the postmaster, they aren't passed ...
    Tom LaneTom Lane
    Sep 29, 2001 at 4:34 am
    Oct 12, 2001 at 5:33 am
  • Well, O_DIRECT has finally made it into the Linux kernel. It lets you open a file in such a way that reads and writes don't go to the buffer cache but straight to the disk. Accesses must be aligned ...
    Doug McNaughtDoug McNaught
    Sep 25, 2001 at 6:57 pm
    Nov 19, 2001 at 4:54 pm
  • I'm trying to update my cvs tree and am currently seeing the following: Parsing supfile "postgres.cvsup" Connecting to cvsup.postgresql.org Cannot connect to cvsup.postgresql.org: Connection refused ...
    Thomas LockhartThomas Lockhart
    Sep 20, 2001 at 8:13 pm
    Sep 26, 2001 at 6:56 am
  • I want to mention that the number of patches submitted has dropped off dramatically. Seems people are prepared for beta and we should start beta as soon as we can. I think the current plan is Friday. ...
    Bruce MomjianBruce Momjian
    Sep 17, 2001 at 4:59 pm
    Sep 26, 2001 at 1:40 am
  • There was a discussion about --enable-syslog by default. What was the consensus? I think this is a good one. -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Sep 11, 2001 at 4:30 am
    Nov 5, 2001 at 4:02 pm
  • I have made lpad/rpad/btrim/ltrim/rtirm/translate functions multibyte aware. I think we could mark following item as "done". * Make functions more multi-byte aware, e.g. trim() Anything I forgot to ...
    Tatsuo IshiiTatsuo Ishii
    Sep 23, 2001 at 11:11 am
    Oct 7, 2001 at 6:42 pm
  • OK, I think we are on track for Monday beta. Marc, will you be packaging a beta1 tarball on Monday or waiting a few days? I need to run pgindent and pgjindent either right before or after beta ...
    Bruce MomjianBruce Momjian
    Sep 29, 2001 at 4:35 am
    Oct 2, 2001 at 2:42 pm
  • what sort of error?
    Marc G. FournierMarc G. Fournier
    Sep 22, 2001 at 1:44 am
    Sep 26, 2001 at 7:44 am
  • I finally got all the way through a compile set: CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \ --with-CXX --with-perl --enable-multibyte --enable-cassert \ ...
    Larry RosenmanLarry Rosenman
    Sep 8, 2001 at 2:06 am
    Sep 10, 2001 at 8:35 am
  • With all the great work put into allowing true 24/7 operation, as distributed we're still unable to rotate the log file. While the log file tends to be smaller than the database system as a whole, ...
    Peter EisentrautPeter Eisentraut
    Sep 6, 2001 at 12:32 am
    Sep 7, 2001 at 9:22 pm
  • In typeconv.sgml we have an example: tgl= select (4.3 !); ?column? ---------- 24 (1 row) However, actually it does not work: test=# select (4.3 !); ERROR: Unable to identify a postfix operator '!' ...
    Tatsuo IshiiTatsuo Ishii
    Sep 10, 2001 at 4:36 am
    Sep 16, 2001 at 9:36 pm
  • Hi guys, I've been looking at CLUSTER today. I've put together a patch which recreates all the indices which current CLUSTER drops and copies relacl from the old pg_class tuple and puts it in the new ...
    Gavin SherryGavin Sherry
    Sep 23, 2001 at 12:56 pm
    Feb 25, 2002 at 4:12 am
  • I just took a dreadful look at the RPMs. I've managed to build something that resembles a 7.2 package, but there are a number of things that we should talk about so this ends up being useful. * The ...
    Peter EisentrautPeter Eisentraut
    Sep 17, 2001 at 3:17 am
    Sep 17, 2001 at 10:18 pm
  • I have heard from Tom Lane that he will be out of town until Wednesday. As with any volunteer project, we can't hold people to dates and schedules. I know he is not done with everything he wants to ...
    Bruce MomjianBruce Momjian
    Sep 11, 2001 at 2:49 am
    Sep 11, 2001 at 9:36 pm
  • Hi, I have a table that contains almost 8 milion rows. The primary key is a sequence, so the index should have a good distribution. Why does the optimizer refuse to use the index for getting the ...
    Reinoud van LeeuwenReinoud van Leeuwen
    Sep 26, 2001 at 12:50 pm
    Oct 13, 2001 at 2:13 pm
  • I posted this in my last message, but have not heard anything yet so I'm wondering if it was overlooked. I need to know how to change a column from being say a varchar(9) to an integer. Does anyone ...
    Gowey, GeoffreyGowey, Geoffrey
    Sep 24, 2001 at 2:20 pm
    Sep 25, 2001 at 1:22 pm
  • I understand that the current port of Postgres for Windows requires the cygwin package. I'd like to understand the requirement for cygwin,and possibly try to port Postgres to run natively on Windows ...
    Dwayne MillerDwayne Miller
    Sep 1, 2001 at 11:25 pm
    Sep 4, 2001 at 7:14 am
  • Now that GreatBridge is gone. (I'm pretty sad about that, they looked like they were working on some cool stuff.) Has this changed, in any way, the development path of PostgreSQL?
    Mark L. WoodwardMark L. Woodward
    Sep 20, 2001 at 12:58 pm
    Sep 22, 2001 at 11:50 pm
  • Hi, This isn't working for me either (no existing checkout) : [justin@justinspc cvs]$ cvs -d :pserver:anoncvs@anoncvs.postgresql.org:/projects/cvsroot login (Logging in to ...
    Justin CliftJustin Clift
    Sep 20, 2001 at 2:07 pm
    Sep 21, 2001 at 10:54 pm
  • All, Just wondering what is the status of this patch. Is seems from comments that people like the idea. I have also looked in the archives for other people looking for this kind of feature and have ...
    Jim ButtafuocoJim Buttafuoco
    Sep 14, 2001 at 9:33 pm
    Mar 3, 2002 at 8:47 pm
  • While looking through the code I found an already existing alter table drop column in src/backend/parser/gram.y. However, when I try to run it in psql it comes back with a not implemented. Was the ...
    Gowey, GeoffreyGowey, Geoffrey
    Sep 21, 2001 at 4:33 pm
    Sep 24, 2001 at 5:50 pm
  • gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -c -o hba.o hba.c hba.c: In function `ident_unix': hba.c:923: sizeof applied to an incomplete type hba.c:960: ...
    Patrick WelchePatrick Welche
    Sep 7, 2001 at 12:55 pm
    Sep 12, 2001 at 2:33 pm
  • Hi, I'm going to add a new function "pg_client_encoding" returning the current client side encoding name. I know there is a similar functionality already there in PostgreSQL (show client_encoding) ...
    Tatsuo IshiiTatsuo Ishii
    Sep 10, 2001 at 4:46 am
    Oct 16, 2001 at 10:11 am
  • I did some benchmarking with/without multibyte support using current. (1) regression test With multibyte support: 9.52user 3.38system 0:59.27elapsed 21%CPU (0avgtext+0avgdata 0maxresident)k Without ...
    Tatsuo IshiiTatsuo Ishii
    Sep 27, 2001 at 5:22 am
    Sep 29, 2001 at 6:05 am
  • When the server starts I see something like DEBUG: redo record is at 0/146ED4; undo record is at 0/0; shutdown TRUE but what does "shutdown TRUE" mean? It doesn't mean "I'm shutting down" nor "the ...
    Peter EisentrautPeter Eisentraut
    Sep 20, 2001 at 4:21 pm
    Sep 21, 2001 at 12:06 am
  • I seem to be unable to access the CVS server: cvs [update aborted]: connect to cvs.postgresql.org:2401 failed: Marc, do you know anthing about this? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Sep 6, 2001 at 12:21 am
    Sep 9, 2001 at 9:10 am
  • (back on list) We have a copy of an SQL99 draft which seems to be reasonably complete. afaik we haven't come across an actual released version. Let me know if you want me to forward it; perhaps it is ...
    Thomas LockhartThomas Lockhart
    Sep 1, 2001 at 1:16 am
    Sep 7, 2001 at 8:23 pm
  • Hi all, By mapping the WAL files by each backend in to its address space using "mmap" system call , there will be big improvements in performance from the following point of view: 1. Each backend ...
    Janardhana ReddyJanardhana Reddy
    Sep 26, 2001 at 11:20 am
    Oct 12, 2001 at 5:42 pm
  • Hi, This is not a real security issue but it seems not very appropreate behavior for me. $ psql -U foo test Password: XXX Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for ...
    Tatsuo IshiiTatsuo Ishii
    Sep 21, 2001 at 10:57 am
    Oct 11, 2001 at 4:54 pm
  • now that the 18gig is in place and I have space once more to work, ftp.postgresql.org now points at the new server (~ftp for those that login) ... let me know if there are any problems ...
    Marc G. FournierMarc G. Fournier
    Sep 30, 2001 at 8:49 pm
    Oct 1, 2001 at 6:58 pm
  • Hi, I have written a small function that show how many tuples are dead etc. in a specified table. Example output is: test=# select pgstattuple('tellers'); NOTICE: physical length: 0.02MB live tuples: ...
    Tatsuo IshiiTatsuo Ishii
    Sep 22, 2001 at 4:36 am
    Sep 22, 2001 at 6:03 am
  • I think that we have concluded that a bigger executable with the unicode conversion functionality does not have any performance penalty. So I would like to remove --enable-unicode-conversion option ...
    Tatsuo IshiiTatsuo Ishii
    Sep 11, 2001 at 4:35 am
    Sep 12, 2001 at 10:23 am
  • This is a very valid concern, and it's been bugging us, too. The problem is that by default, the majority of users would probably want the Perl and Python modules to be put in the default place where ...
    Peter EisentrautPeter Eisentraut
    Sep 4, 2001 at 12:54 pm
    Sep 11, 2001 at 3:01 pm
  • I just noticed some unexpected behavior from byteain: test=# select '\\009'::bytea; ?column? ---------- \011 (1 row) test=# select '\\444'::bytea; ?column? ---------- $ (1 row) test=# select ...
    Joe ConwayJoe Conway
    Sep 7, 2001 at 3:11 am
    Sep 7, 2001 at 2:26 pm
  • All, I am working a some patches to the code and I noticed that "pg_dump -C database" doesn't provide the database location information in the dump file. Is this correct? Thanks Jim Example: datname ...
    Jim ButtafuocoJim Buttafuoco
    Sep 9, 2001 at 12:44 pm
    Oct 11, 2001 at 4:35 pm
  • Have you recompiled PHP to link against the new postgres libraries? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 27, 2001 at 1:32 am
    Oct 1, 2001 at 3:13 pm
  • I'm trying to use an integer from a table to add/subtract time in months. IOW: create table foo(nummonths int); select now() - nummonths months; So far nothing I've tried will work - short of a ...
    Vince VielhaberVince Vielhaber
    Sep 26, 2001 at 8:30 pm
    Sep 27, 2001 at 1:27 am
  • I have just upgraded to the new PostgreSQL 7.1.3 (from 7.0.3) and have been experiencing a pretty serious problem: On one particular page, in what seems to be completely random instances, I get ...
    Mike RogersMike Rogers
    Sep 26, 2001 at 4:13 pm
    Sep 26, 2001 at 5:17 pm
  • I'm looking at pg_proc.h to adjust the cacheable attribute for date/time functions. Can anyone recall why the interval data type would have been considered non-cacheable? I didn't make internal ...
    Thomas LockhartThomas Lockhart
    Sep 26, 2001 at 1:06 pm
    Sep 26, 2001 at 3:01 pm
  • I have split the timestamp data type into two types to better match SQL9x specs. I've implemented them as "timestamp" and "timestamptz" (the latter corresponding to the implementation in recent ...
    Thomas LockhartThomas Lockhart
    Sep 20, 2001 at 2:10 am
    Sep 20, 2001 at 5:02 pm
  • New problems with CVSup. We should all upgrade asap, though I'm not sure of the current status of builds for non-FreeBSD machines. Marc, could we possibly install this on the postgresql.org ...
    Thomas LockhartThomas Lockhart
    Sep 12, 2001 at 5:51 pm
    Sep 19, 2001 at 2:43 pm
  • Hi dear people, (My condolences to all afected by terrorist acts in US) As I have been telling for a while, GeneXus database rapid application developing tool, will now add to its set of four ...
    Haroldo StengerHaroldo Stenger
    Sep 13, 2001 at 2:28 am
    Sep 13, 2001 at 5:52 pm
  • Hi dear people, Now I'm reposting this on hackers from general, sorry if no fully suitable. We are building a RAD tool (GeneXus) support, for PostgreSQL, as I have mentioned before a number of times. ...
    Haroldo StengerHaroldo Stenger
    Sep 8, 2001 at 3:14 pm
    Sep 10, 2001 at 12:23 pm
Sep 2001
1234
Group Navigation
period‹ prev | Sep 2001 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions188
posts895
users134
websitepostgresql.org...
irc#postgresql

134 users for September 2001

Bruce Momjian: 142 posts Tom Lane: 117 posts Peter Eisentraut: 58 posts Marc G. Fournier: 42 posts Tatsuo Ishii: 41 posts Thomas Lockhart: 36 posts Christopher Kings-Lynne: 22 posts Karel Zak: 16 posts Jim Buttafuoco: 15 posts Mark L. Woodward: 15 posts Alex Pilosov: 13 posts Joe Conway: 13 posts Gowey, Geoffrey: 12 posts Larry Rosenman: 12 posts Hannu Krosing: 10 posts Justin Clift: 10 posts Haller Christoph: 9 posts Lamar Owen: 9 posts Patrick Welche: 9 posts Vadim Mikheev: 9 posts
show more
Archives