FAQ

PostgreSQL > pgsql-hackers > August 2005

Search Discussions

151 discussions - 1,191 posts

  • Currently, here are the options available for wal_sync_method: #wal_sync_method = fsync # the default varies across platforms: # fsync, fdatasync, fsync_writethrough, # open_sync, open_datasync I ...
    Bruce MomjianBruce Momjian
    Aug 8, 2005 at 7:56 pm
    Aug 29, 2005 at 3:20 pm
  • Hello, I have negotiated with the author of pl/Ruby to release plRuby under the PostgreSQL license. The reason I did this is the following: 1. I felt we needed a truly OO language in core. 2. ...
    Joshua D. DrakeJoshua D. Drake
    Aug 15, 2005 at 5:28 pm
    Aug 18, 2005 at 12:42 am
  • I have compiled the 8.1 release notes and converted them to SGML at: http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1 I still need to add markup and cleanup, but it is good ...
    Bruce MomjianBruce Momjian
    Aug 23, 2005 at 3:16 am
    Aug 25, 2005 at 12:34 am
  • Don't know if anyone else has noticed, but cvsweb is a bit slow right now and mailing list response times have gotten really slow. Could we use more machines or bandwidth? -- Jim C. Nasby, Sr. ...
    Jim C. NasbyJim C. Nasby
    Aug 24, 2005 at 10:37 pm
    Aug 26, 2005 at 5:09 pm
  • I saw in the release notes that 8.1 is supposed to do function syntax checking at create rather than run time, but with the first beta this does not seem to work. check function bodies is on by ...
    Tony CadutoTony Caduto
    Aug 31, 2005 at 4:39 pm
    Sep 2, 2005 at 2:26 am
  • Hi all, I've done a quick hack to implement PCTFREE on PostgreSQL. As you know, it's inspired by Oracle's PCTFREE. http://www.csee.umbc.edu/help/oracle8/server.815/a67772/schema.htm#990 ...
    Satoshi NagayasuSatoshi Nagayasu
    Aug 22, 2005 at 12:03 am
    Sep 2, 2005 at 12:52 am
  • I was reminded again today of the problem that once a database has been in existence long enough for the OID counter to wrap around, people will get occasional errors due to OID collisions, eg ...
    Tom LaneTom Lane
    Aug 3, 2005 at 11:43 pm
    Aug 10, 2005 at 9:40 pm
  • While marking up TODO for potential new-hacker items I've run across some items that probably need more explanation: o Allow commenting of variables in postgresql.conf to restore them to defaults ...
    Jim C. NasbyJim C. Nasby
    Aug 24, 2005 at 5:44 am
    Aug 26, 2005 at 7:48 pm
  • It seems to me that contrib/dblink could greatly simplify the design and coding of multi-user regression tests. Is there objection to a portion of src/test/regress depending on contrib/dblink? I'm ...
    Matt MillerMatt Miller
    Aug 10, 2005 at 7:17 pm
    Aug 22, 2005 at 9:35 pm
  • Hi, With a help from Bruce, I wrote a small function which returns row locking information(see attached file if you are interested). Here is a sample result: test=# select * from pgrowlocks('t1'); ...
    Tatsuo IshiiTatsuo Ishii
    Aug 7, 2005 at 12:47 pm
    Apr 23, 2006 at 1:14 am
  • 8.1-beta1 produces some odd results with statement logging enabled when the extended query protocol is used (e.g. when using the JDBC driver). Repeatedly running a simple query with log_statement = ...
    Oliver JowettOliver Jowett
    Aug 31, 2005 at 2:34 am
    Sep 25, 2005 at 11:27 pm
  • Is anybody working on allowing indexes to span multiple tables? IF not, I'll give it a try. -- Make April 15 just another day, visit http://fairtax.org
    Joshua N PritikinJoshua N Pritikin
    Aug 22, 2005 at 6:31 pm
    Aug 24, 2005 at 2:06 pm
  • I have an example of runs that illustrate a performance problem that occurred between installing the 7/18 and 8/1 development release codes. I'm running on a PPC64 8-way system, with 16GB of memory ...
    Mary Edie MeredithMary Edie Meredith
    Aug 11, 2005 at 10:13 pm
    Aug 29, 2005 at 9:36 pm
  • Would anybody object to a patch to update psql's tab completion for SET/RESET/SHOW to include everything that SHOW shows for a superuser? I count about 65 variables that SHOW shows that are missing ...
    Michael FuhrMichael Fuhr
    Aug 13, 2005 at 6:01 am
    Aug 22, 2005 at 8:01 pm
  • I made a pass over the TODO list to see what was out of date. This comment may be out of date. Suggest Lock table corruption following SIGTERM of an individual backend has been reported in 8.0. A ...
    Tom LaneTom Lane
    Aug 25, 2005 at 1:58 am
    Aug 26, 2005 at 10:15 pm
  • What do people think of exposing pg_usleep() to the user? It's sometimes useful to have a server-side sleep function, and people do ask about it occasionally (e.g., Don Drake today in pgsql-admin). ...
    Michael FuhrMichael Fuhr
    Aug 21, 2005 at 10:52 pm
    Aug 24, 2005 at 5:55 pm
  • For a while now, I've been seeking a method of reducing the impact of VACUUM when run against a database where 80-95% of the data is effectively read only and will not be deleted/updated again. This ...
    Simon RiggsSimon Riggs
    Aug 31, 2005 at 10:17 pm
    Sep 22, 2005 at 7:15 am
  • Once more: I would like to get at least some answer, why my patch for enabling concurrent VACUUM was left out from 8.1. It was submitted well in time, and there was only minimal amount of discussion ...
    Hannu KrosingHannu Krosing
    Aug 16, 2005 at 9:02 pm
    Aug 23, 2005 at 6:58 am
  • Hello, I just found quite a strange behaviour of 8.1beta on SunOS: uname -a: SunOS sun46 5.8 Generic_108528-14 sun4u sparc SUNW,Ultra-80 gcc -v: Reading specs from ...
    Sergey E. KoposovSergey E. Koposov
    Aug 29, 2005 at 11:50 am
    Aug 30, 2005 at 5:12 pm
  • I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL)
    Mark L. WoodwardMark L. Woodward
    Aug 3, 2005 at 8:55 pm
    Sep 16, 2005 at 3:55 pm
  • It looks like when we changed regress/GNUmakefile to pull rules from Makefile.shlib, cygwin got broken in the process. The problem is that regess.dll ends up being a symlink back to itself, because ...
    Rocco AltierRocco Altier
    Aug 4, 2005 at 7:05 pm
    Aug 9, 2005 at 6:09 am
  • Hi, As part of previous discussions about typmod for user type, Tom mentioned that you would need to make type and function names equivalent. As it turns out, if you refactor a few rules, you can ...
    Martijn van OosterhoutMartijn van Oosterhout
    Aug 31, 2005 at 1:32 pm
    Jun 14, 2006 at 5:56 pm
  • Has anyone been able to set kern.sysv.shmmax above 4MB at all in latest OS X? I just spent a while trying what seemed every possible permutation of setting up /etc/sysctl.conf and editing /etc/rc ...
    Tom LaneTom Lane
    Aug 30, 2005 at 12:18 am
    Oct 16, 2005 at 8:49 pm
  • Unfortunately I just found that we still cannot build in thread safety mode on Windows, due to an error on my part - specifically, I concentrated on libpq, not realising that ecpglib is also thread ...
    Dave PageDave Page
    Aug 24, 2005 at 9:50 pm
    Aug 29, 2005 at 3:19 pm
  • Hello, What might this be? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support ...
    Joshua D. DrakeJoshua D. Drake
    Aug 1, 2005 at 6:57 pm
    Aug 9, 2005 at 6:33 pm
  • "create user foo with createdb" will create a user with createdb privilege. "create user bar with createuser" will create s superuser who can createdb, createuser, and update system catalog. Why not ...
    William ZHANGWilliam ZHANG
    Aug 12, 2005 at 10:14 am
    Aug 24, 2005 at 7:50 am
  • Currently, pg_config will tell about the configure options that were used, but it does not let you find out if any environment variables were used to determine CC, CFLAGS, etc. More than once I've ...
    Tom LaneTom Lane
    Aug 9, 2005 at 6:49 pm
    Aug 14, 2005 at 9:47 pm
  • The core committee has agreed that we need to do a set of releases in the back branches soon --- certainly 8.0 has accumulated a critical mass of changes since 8.0.3, and probably there's enough to ...
    Tom LaneTom Lane
    Aug 15, 2005 at 5:06 pm
    Aug 17, 2005 at 12:53 pm
  • Folks, we need to address the questions asked in this email and get it into CVS soon. --------------------------------------------------------------------------- Magnus Hagander wrote: ...
    Bruce MomjianBruce Momjian
    Aug 13, 2005 at 3:05 am
    Aug 24, 2005 at 4:59 pm
  • Hello, As I have been laboring over the documentation of the postgresql.conf file for 8.1dev it seems that it may be useful to rip out most of the options in this file? Considering many of the ...
    Joshua D. DrakeJoshua D. Drake
    Aug 7, 2005 at 9:14 pm
    Aug 8, 2005 at 9:04 pm
  • Folks, I've noticed that \df doesn't do quite what it might when a function is created with named input parameters. Please find enclosed a patch against CVS TIP that does this better. On a slightly ...
    David FetterDavid Fetter
    Aug 29, 2005 at 3:19 am
    Sep 23, 2005 at 8:32 pm
  • I'm currently testing pgAdmin support for slony, on pgsql CVS HEAD, and encounter strange problems from time to time. After dropping and recreating the slony schema, all changes committed and all ...
    Andreas PflugAndreas Pflug
    Aug 28, 2005 at 8:23 pm
    Aug 30, 2005 at 11:04 pm
  • Project members: On behalf of the PostgreSQL Core Team, I welcome Dave Page. Dave has been the head of the pgODBC project for a couple of years, started the pgAdmin project in 1998, has been our lead ...
    Josh BerkusJosh Berkus
    Aug 26, 2005 at 12:56 am
    Aug 26, 2005 at 8:55 pm
  • I have just managed to get pg server and client (cvs tip) talking IPv6 on Windows. :-) 1. Building - added in library in configure.in: AC_CHECK_LIB(ws2_32, main) - faked out getaddrinfo test in ...
    Andrew DunstanAndrew Dunstan
    Aug 18, 2005 at 10:16 pm
    Aug 19, 2005 at 5:17 pm
  • Dear PostreSQL hackers, For the interested, here: http://www.cs.utwente.nl/~hiemstra/courses/reports/sqlxml.pdf you find a little report discussing possibilities to implement the SQL/XML standard ...
    Djoerd HiemstraDjoerd Hiemstra
    Aug 18, 2005 at 8:50 am
    Mar 21, 2006 at 12:18 pm
  • I have a table with several 'smallint' fields that I'd like to convert to booleean ... the data in each is either 0 or 1, and: # select '1'::boolean; bool ------ t (1 row) # select '0'::boolean; bool ...
    Marc G. FournierMarc G. Fournier
    Aug 29, 2005 at 11:15 pm
    Sep 1, 2005 at 10:16 pm
  • Context diff, please, diff -c. --------------------------------------------------------------------------- Chuck McDevitt wrote: Content-Description: getaddrinfo.patch [ Attachment, skipping... ] -- ...
    Bruce MomjianBruce Momjian
    Aug 24, 2005 at 7:07 pm
    Aug 25, 2005 at 8:31 am
  • Hi all, I propose to add an internal function gettime() that transparently returns the current system time, as a timestamptz with maximum precision. Calling gettime() would be a more elegant approach ...
    Brendan JurdBrendan Jurd
    Aug 7, 2005 at 6:10 am
    Aug 17, 2005 at 10:27 pm
  • Did we recently make some fixes for FBSD that cured the problem with unresolved pthread* symbols for plpython? If so, should we look at possibly doing something similar for OpenBSD? That might clean ...
    Andrew DunstanAndrew Dunstan
    Aug 3, 2005 at 2:33 pm
    Sep 26, 2005 at 4:48 pm
  • Is enable_constraint_exclusion the proper name for this feature? I know we have enable* in the optimizer settings, but that naming seems unfortunate in that we should have just called it hash_join ...
    Bruce MomjianBruce Momjian
    Aug 19, 2005 at 8:56 pm
    Aug 22, 2005 at 10:08 pm
  • [ redirected to -hackers ] I wrote: After a quick look through the code, it seems like the way to do this is to add an extra bool parameter "nest_triggers" to _SPI_pquery, which when false would ...
    Tom LaneTom Lane
    Aug 16, 2005 at 3:00 pm
    Aug 22, 2005 at 8:54 pm
  • I had posted this earlier, but had insufficient info (or access) to provide much detail ... now, I've got the access, and this really isn't making much sense ... Have databse that \ds shows several ...
    Marc G. FournierMarc G. Fournier
    Aug 2, 2005 at 7:31 pm
    Aug 3, 2005 at 2:43 am
  • [Please CC any replies, thanks] Hi, I saw the discussion about an tester for MVCC. Since I'd never done anything with asyncronous queries before, I figured I'd try to write something useful with it. ...
    Martijn van OosterhoutMartijn van Oosterhout
    Aug 29, 2005 at 10:56 pm
    Sep 6, 2005 at 9:04 pm
  • I just noticed that AlterSchemaOwner (and others like AlterFunctionOwner -- I haven't checked anything else yet) does not release the lock on pg_namespace (resp. AlterFunctionOwner) after it's done ...
    Alvaro HerreraAlvaro Herrera
    Aug 19, 2005 at 4:13 pm
    Aug 20, 2005 at 2:28 pm
  • Hi! I played around with roles a bit today and noticed some minor things: ALTER ROLE seems to support ALTER ROLE <name ROLE <name - but that form is not mentioned in the docs: playground=# CREATE ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Aug 15, 2005 at 9:46 am
    Sep 23, 2005 at 10:25 pm
  • I thought some more about this and came up with a sketch of a solution. This would solve the problem of loading subtly-bogus language definitions from existing dump files, and it also offers a ...
    Tom LaneTom Lane
    Aug 31, 2005 at 9:56 pm
    Sep 2, 2005 at 8:29 pm
  • Hi, I've recently had problems with slow queries caused by the selectivity of the <@ ltree operator, as you may see in my post here: ...
    Matteo BeccatiMatteo Beccati
    Aug 4, 2005 at 2:37 pm
    Aug 13, 2005 at 3:05 am
  • [Please CC any replies so I don't have to follow them via the archives] Hi, I'm trying to create a set of types that are going to share the INPUT and OUTPUT functions (written in C). For output you ...
    Martijn van OosterhoutMartijn van Oosterhout
    Aug 11, 2005 at 3:33 pm
    Aug 12, 2005 at 9:50 pm
  • I just spent a tedious hour digging through the buildfarm results to see what I could learn about the intermittent failures we're seeing in the stats regression test, such as here: ...
    Tom LaneTom Lane
    Aug 30, 2005 at 4:30 am
    Aug 31, 2005 at 12:36 am
  • This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. ---559023410-560155114-1125148906=:16397 ...
    Oleg BartunovOleg Bartunov
    Aug 27, 2005 at 1:21 pm
    Aug 27, 2005 at 6:32 pm
Aug 2005
1234
Group Navigation
period‹ prev | Aug 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions151
posts1,191
users154
websitepostgresql.org...
irc#postgresql

154 users for August 2005

Tom Lane: 237 posts Bruce Momjian: 130 posts Andrew Dunstan: 64 posts Jim Nasby: 53 posts Alvaro Herrera: 35 posts Joshua D. Drake: 33 posts Josh Berkus: 27 posts Michael Fuhr: 25 posts Dave Page: 21 posts Marc G. Fournier: 20 posts Simon Riggs: 20 posts Magnus Hagander: 19 posts Hannu Krosing: 18 posts Marko Kreen: 17 posts Mark L. Woodward: 16 posts Stephen Frost: 15 posts Christopher Kings-Lynne: 14 posts David Fetter: 14 posts Martijn van Oosterhout: 13 posts Greg Stark: 12 posts
show more
Archives