FAQ

Search Discussions

146 discussions - 1,021 posts

  • Hi, [ moving to -hackers, that seems more appropriate. ] Jeff Davis wrote: I'd love to get into that one. Some of the people who have attended my talk at the summit might know that I've introduced ...
    Markus SchiltknechtMarkus Schiltknecht
    Nov 22, 2006 at 6:23 pm
    Dec 6, 2006 at 11:33 pm
  • Here's what I see as the remaining things we need to resolve before wrapping 8.2RC1: * Brendan Jurd's recent report about from_char/to_char not being consistent about 'D': ...
    Tom LaneTom Lane
    Nov 24, 2006 at 7:55 pm
    Nov 28, 2006 at 4:02 pm
  • Design Overview of HOT Updates ------------------------------ The objective is to increase the speed of the UPDATE case, while minimizing the overall negative effects of the UPDATE. We refer to the ...
    Simon RiggsSimon Riggs
    Nov 9, 2006 at 5:13 pm
    Nov 17, 2006 at 8:18 pm
  • I've been looking at adding SASL or GSSAPI as an auth method. I have some questions about how to handle the flow of control changes. When you do one of the above, an authentication is not ...
    Henry B. HotzHenry B. Hotz
    Nov 1, 2006 at 12:14 am
    Nov 4, 2006 at 11:00 pm
  • Hm, that should work --- AFAICS the startup process should abort on SIGQUIT the same as any regular backend. [ thinks... ] Ah-hah, "man system(3)" tells the tale: system() ignores the SIGINT and ...
    Tom LaneTom Lane
    Nov 17, 2006 at 10:03 pm
    Nov 30, 2006 at 9:40 pm
  • I just realized that we have a bit of a problem with upgrading row locks. Consider the following sequence: regression=# begin; BEGIN regression=# select * from int4_tbl where f1 = 0 for share; f1 ...
    Tom LaneTom Lane
    Nov 30, 2006 at 10:06 pm
    Feb 1, 2007 at 4:36 am
  • Josh Berkus asked me recently what cool things I would be working on now. I have just received the go ahead to work on this TODO item for the next release: Add optional textual message to NOTIFY This ...
    Andrew DunstanAndrew Dunstan
    Nov 30, 2006 at 11:09 pm
    Dec 18, 2006 at 8:34 pm
  • Hi! Now we (Oleg and me) are working on moving tsearch into core. Pls, review suggested syntax. Comments, suggestions, objections will be appreciated. 1) parser operation (pg_ts_parser table) CREATE ...
    Teodor SigaevTeodor Sigaev
    Nov 17, 2006 at 11:55 am
    Nov 20, 2006 at 10:18 pm
  • It seems possible to vary both BLCKSZ and XLOGSEGSZ rather than have them set within pg_config_manual. There are a number of use-cases where varying these values will offer increased performance (and ...
    Simon RiggsSimon Riggs
    Nov 27, 2006 at 11:30 am
    Feb 5, 2007 at 4:26 pm
  • In 8.2, utils/adt/formatting.c uses our NLS mechanism to localize day and month names (I assume for use by to_char). But since this necessarily ties the outcome to the LC_MESSAGES setting, this comes ...
    Peter EisentrautPeter Eisentraut
    Nov 17, 2006 at 4:40 pm
    Feb 14, 2007 at 9:00 pm
  • Hi First time PostgreSQL user. Here's a review of my experience so far. 1.) Reading the manual Looks good feature-wise, but there's a suspicious lack of reference to any kind of repair utility for ...
    Molle BestefichMolle Bestefich
    Nov 20, 2006 at 4:10 pm
    Dec 25, 2006 at 3:06 am
  • I've noticed a trend in the PostgreSQL code base - for some reason, we tend to avoid initializing automatic variables (actually, the code base is pretty mixed on this point). For example in ...
    KorrydKorryd
    Nov 2, 2006 at 6:34 pm
    Nov 3, 2006 at 5:07 pm
  • I'm trying to create a custom data type similar to an enumeration type. However, I'd like the mapping of the int<- string to be dynamic instead of hard coded. I'd like to have a table that contains ...
    Greg MitchellGreg Mitchell
    Nov 15, 2006 at 9:18 pm
    Nov 21, 2006 at 2:30 pm
  • Redirecting from -general. Okay, I patched. The patch follows. Please comment. In particular, I've just copied the CURRENT_TIMESTAMP code block in gram.y. Is this the best approach? I saw similar ...
    Matt MillerMatt Miller
    Nov 18, 2006 at 12:05 am
    Dec 1, 2006 at 5:42 am
  • It would be clearer to just have a separate function. regards, tom lane
    Tom LaneTom Lane
    Nov 24, 2006 at 4:38 am
    Nov 27, 2006 at 9:20 am
  • Good point. Do we want to consider that this is a code bug rather than a doc bug? The relative path is more efficient as long as the archiver script doesn't do a "cd", but if it does then there'd be ...
    Tom LaneTom Lane
    Nov 3, 2006 at 4:25 pm
    Nov 8, 2006 at 10:20 am
  • Here is a localization bug waiting to happen: static char * localize_month_full(int index) { char *m = NULL; switch (index) { case 4: m = _("May"); break; static char * localize_month(int index) { ...
    Peter EisentrautPeter Eisentraut
    Nov 27, 2006 at 11:40 am
    Nov 28, 2006 at 10:57 pm
  • I have update the 8.2 open items list: http://momjian.postgresql.org/cgi-bin/pgopenitems -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, ...
    Bruce MomjianBruce Momjian
    Nov 23, 2006 at 6:04 am
    Nov 27, 2006 at 7:00 pm
  • Hi, We (Fabalabs) are looking into adding XA support (distributed transactions) to Postgresql. I have been searching the web and came up with ...
    Danny MilosavljevicDanny Milosavljevic
    Nov 20, 2006 at 5:16 pm
    Nov 26, 2006 at 11:14 pm
  • Hi, I'm playing with GIN to make a full text search system. GIN comes with built-in TEXT[] support and I use string_to_array() to make a TEXT[]. Problem is, if there's large number of array elemets, ...
    Tatsuo IshiiTatsuo Ishii
    Nov 8, 2006 at 5:40 am
    Nov 9, 2006 at 8:26 am
  • Is there a reason other than existing code why HBA should not allow "ident" to be combined with other authentication methods? Right now there's no fall-back mechanism for when an ident map doesn't ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Nov 26, 2006 at 11:35 am
    Nov 30, 2006 at 8:18 am
  • Any reason not to support renaming columns? Can this be added to TODO?
    Jim NasbyJim Nasby
    Nov 17, 2006 at 5:59 am
    Nov 21, 2006 at 5:46 am
  • In the bufmgr code we keep track of reference counts on individual buffers. We do this with a local array that grows in proportion to the size of shared_buffers. When we have a high shared_buffers, ...
    Simon RiggsSimon Riggs
    Nov 27, 2006 at 10:40 am
    Mar 6, 2007 at 6:47 am
  • Hi all, I am experiencing strange problem using tsearch with polish locale on (initdb -locale pl_PL.iso88592) and polish ispell dictionary. I have a pl/pgSQL function that creates tsvector for a ...
    Arkadiusz StaronArkadiusz Staron
    Nov 20, 2006 at 10:45 am
    Dec 1, 2006 at 1:06 pm
  • While working on fixing the recently reported hash-index problem, I was using a test build with a very small RELSEG_SIZE (128K), so that I could trigger the reported bug with a reasonably small ...
    Tom LaneTom Lane
    Nov 19, 2006 at 12:34 am
    Nov 19, 2006 at 8:29 pm
  • We are trying to get something faster than ~ '%foo%'; Which Tsearch2 does not give us :) Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || ...
    Joshua D. DrakeJoshua D. Drake
    Nov 1, 2006 at 3:46 am
    Nov 2, 2006 at 10:00 am
  • We are currently debugging a problem with error messages like this: ERROR: 53100: could not write block 2427137 of relation 1663/706306048/706314280: No space left on device The device has plenty of ...
    Peter EisentrautPeter Eisentraut
    Nov 28, 2006 at 3:51 pm
    Nov 30, 2006 at 9:07 pm
  • OK. OK. I am still feeling that data partitioning is like master/slave replication because you have to get that read-only copy to the other server. If you split things up so data sets resided on only ...
    Bruce MomjianBruce Momjian
    Nov 17, 2006 at 5:06 am
    Nov 21, 2006 at 9:38 pm
  • Hello hackers, I noticed that the table description given by \d <tablename in psql does not indicate whether a trigger is enabled or disabled. In my opinion, if a trigger is disabled, that fact is ...
    Brendan JurdBrendan Jurd
    Nov 6, 2006 at 3:44 am
    Jan 20, 2007 at 9:22 pm
  • One exceedingly minor logging issue I just noticed in looking at the log from a beta3. [2006-11-28 06:37:08.152 CST] 14775 <postgres dtr [local] NOTICE: number of page slots needed (2296208) exceeds ...
    Kevin GrittnerKevin Grittner
    Nov 28, 2006 at 5:39 pm
    Dec 5, 2006 at 9:37 pm
  • Hi... i'm using debian sarge and when trying to compile 8.2beta3 got this fail... gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing -g -Wno-error ...
    Jaime CasanovaJaime Casanova
    Nov 12, 2006 at 7:31 pm
    Nov 12, 2006 at 9:47 pm
  • Compiled fine. Still a few warnings (using Fedora Core 6 / AMD64). The new PG_MAGIC_MODULE requirement threw me for a loop. I expect it will catch others off guard as well. One of my complicated ...
    MarkMark
    Nov 5, 2006 at 6:15 am
    Nov 11, 2006 at 1:54 am
  • EnterpriseDB has been running a research project to improve the performance of heavily updated tables. We have a number of approaches prototyped and we'd like to discuss the best of these now on ...
    Simon RiggsSimon Riggs
    Nov 6, 2006 at 9:52 pm
    Nov 9, 2006 at 11:17 pm
  • I don't think this works. RelationCacheInitFileInvalidate is executed post-commit, which means that there's a window between commit and where you propose to write the WAL entry. A crash and restart ...
    Tom LaneTom Lane
    Nov 1, 2006 at 7:33 pm
    Nov 5, 2006 at 11:42 pm
  • There have been several reports that people could not vacuum any more or observed strange locks even after server restart. The reason was that they still had uncommitted prepared transactions around. ...
    Joachim WielandJoachim Wieland
    Nov 3, 2006 at 4:30 am
    Feb 14, 2007 at 4:19 am
  • vacuumlazy.c contains a hint "Consider compacting this relation" but AFAICT, there is no indication anywhere how "compacting" is supposed to be achieved. I guess this means VACUUM FULL or CLUSTER, ...
    Peter EisentrautPeter Eisentraut
    Nov 29, 2006 at 10:19 am
    Feb 5, 2007 at 5:20 pm
  • Hi, I'm sorry I write so late with final aproaching with all beta and rc versions of 8.2 I have those (apparently harmless) warnings at configure time. Maybe a configure guru could have a quick look. ...
    OhpOhp
    Nov 30, 2006 at 1:07 pm
    Nov 30, 2006 at 10:14 pm
  • Hello, I tested TM formating with czech names. Upper case chars in name are not correct. Function upper works perfectly. Sample: postgres=# select to_char(date '2006-02-03', 'TMday'); to_char ...
    Pavel StehulePavel Stehule
    Nov 29, 2006 at 9:32 am
    Nov 29, 2006 at 8:41 pm
  • Hello, Is there anything that may prevent two PostgreSQL servers to share the same pg_xlog directory; while one is using read-only and the other one is using the same partition for read and write? ...
    Devrim GÃNDÃZDevrim GÃNDÃZ
    Nov 27, 2006 at 12:41 pm
    Nov 28, 2006 at 3:13 pm
  • [moving to -hackers] I wrote: Well, if anyone cast eyeballs over it they kept it secret from me :-( However, I have now tested the patch with the little script shown below and it seems to do the ...
    Andrew DunstanAndrew Dunstan
    Nov 12, 2006 at 4:03 pm
    Nov 21, 2006 at 2:08 pm
  • I've reposted this from pgsql-performance where I got no response. ========================================== Hi, I wanted to use "exp1 is not distinct from exp2" which I tough was syntaxic sugar for ...
    JEAN-PIERRE PELLETIERJEAN-PIERRE PELLETIER
    Nov 1, 2006 at 9:38 pm
    Nov 8, 2006 at 8:43 am
  • One thing I want to look at for 8.3 is improving custom variable classes. Right now these are all user settable, which makes them quite inappropriate for security related settings (such as which perl ...
    Andrew DunstanAndrew Dunstan
    Nov 28, 2006 at 6:17 pm
    Feb 4, 2007 at 4:07 am
  • I've now got to custom datatypes that map from an int2 value on disk to a string by way of a table for each. Currently, I load these tables into a dynahash per function call (fcinfo- flinfo- ...
    Greg MitchellGreg Mitchell
    Nov 27, 2006 at 4:22 pm
    Dec 5, 2006 at 5:41 pm
  • Hello, We are using PQputline function for copying data to database Postgres version 7.2.4 Following is the code snapshot: We are taking data from one database, 100 records at time and storing that ...
    Soni deSoni de
    Nov 29, 2006 at 6:32 am
    Nov 30, 2006 at 8:43 am
  • There seem to be a number of issues with our libedit support. One of them is that we fail to build on Linux (at least on Debian Etch/4.0 x86_64 and i386) if libedit-dev is installed but not ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Nov 29, 2006 at 7:47 pm
    Nov 29, 2006 at 9:43 pm
  • The various ports and FAQs are fairly confusing, I note. http://www.postgresql.org/docs/faq/ - AIX FAQ could do with some work, its long with lots of As and not many Qs, so its hard to understand ...
    Simon RiggsSimon Riggs
    Nov 28, 2006 at 8:14 am
    Nov 28, 2006 at 7:32 pm
  • I was thinking a bit about a problem that was mentioned in the discussion TomD, Simon Rigga and I had about enums and foreign keys, namely that often we find dozens of tiny little reference tables ...
    Andrew DunstanAndrew Dunstan
    Nov 22, 2006 at 6:33 pm
    Nov 26, 2006 at 11:05 pm
  • First guys, thanks for the help getting my mapped data types together. They work great until I run a query on a table where one is an index column. The planner produces really bad plans (uses nested ...
    Greg MitchellGreg Mitchell
    Nov 22, 2006 at 1:17 am
    Nov 22, 2006 at 10:34 pm
  • These are logs from Beta 2. Did I miss a discussion where we removed the name of the portal during parse, and bind ? 5715%2006-11-01 01:02:26.631 PST%454862a0.1653%SELECT LOG: execute S_2: select ...
    Dave CramerDave Cramer
    Nov 1, 2006 at 3:27 am
    Nov 1, 2006 at 9:12 pm
  • Hi all, I noticed that during client authentication by HBA, some times we will necessarily determine whether or not a role exists. For example, password, crypt and md5 auth methods call ...
    Gavin SherryGavin Sherry
    Nov 30, 2006 at 3:33 am
    Feb 8, 2007 at 4:52 am
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions146
posts1,021
users148
websitepostgresql.org...
irc#postgresql

148 users for November 2006

Tom Lane: 196 posts Simon Riggs: 67 posts Andrew Dunstan: 54 posts Bruce Momjian: 53 posts Joshua D. Drake: 36 posts Peter Eisentraut: 30 posts Martijn van Oosterhout: 24 posts Alvaro Herrera: 21 posts Josh Berkus: 21 posts Markus Schiltknecht: 21 posts Neil Conway: 17 posts Teodor Sigaev: 17 posts Magnus Hagander: 15 posts Andrew Sullivan: 14 posts Heikki Linnakangas: 14 posts Stephen Harris: 13 posts Florian G. Pflug: 11 posts Andreas Zeugswetter: 10 posts Brendan Jurd: 9 posts Euler Taveira de Oliveira: 9 posts
show more
Archives