FAQ

Search Discussions

151 discussions - 1,252 posts

  • Having just optimized COPY to avoid writing WAL during the transaction in which a table was first created, it seems worth considering whether this should occur for INSERT, UPDATE and DELETE also. It ...
    Simon RiggsSimon Riggs
    Dec 22, 2005 at 2:31 pm
    Feb 8, 2006 at 2:01 am
  • In looking at the current pgbench results, I notice that one considerable contribution to LWLock contention is access to the heavyweight-lock manager. Almost all of that comes from taking ...
    Tom LaneTom Lane
    Dec 2, 2005 at 2:37 am
    Mar 4, 2006 at 5:02 am
  • So it appears that pg_md5_encrypt is not officially exported from libpq. Does anyone see a problem with adding it to the export list and the header file? -- Peter Eisentraut ...
    Peter EisentrautPeter Eisentraut
    Dec 19, 2005 at 1:32 am
    Dec 23, 2005 at 6:06 pm
  • There are currently some rather crude knobs for persuading the planner to favour certain kinds of query plans: the enable_XXX GUC variables. Several people have asked for a more flexible way to give ...
    Neil ConwayNeil Conway
    Dec 1, 2005 at 10:23 am
    Dec 8, 2005 at 7:18 pm
  • Well, that fixed-size buffer is now used only for sprintf(). The others use the specified length (for snprintf()) or output directly to the FILE* stream. Seems Tom didn't like that and no one else ...
    Bruce MomjianBruce Momjian
    Dec 4, 2005 at 3:45 am
    Dec 6, 2005 at 3:43 pm
  • Seems we don't link against the port/qsort.c - is there any reason for that? My tests indicates our qsort is much much faster than the libc's. Regards, Qingqing
    Qingqing ZhouQingqing Zhou
    Dec 12, 2005 at 4:41 pm
    Dec 17, 2005 at 2:15 am
  • Hi, there's a topic that comes up from time to time on the lists, the problem that pgsql functions get planned only once and thereafter the same query plan is used until server shutdown or explicit ...
    Joachim WielandJoachim Wieland
    Dec 13, 2005 at 9:32 pm
    Dec 22, 2005 at 11:06 pm
  • I encountered an error today (can't repeat) on SunOS 5.8: --test that we read consecutive LFs properly CREATE TEMP TABLE testnl (a int, b text, c int); + ERROR: could not open relation ...
    Qingqing ZhouQingqing Zhou
    Dec 30, 2005 at 5:08 am
    Jan 3, 2006 at 5:11 am
  • What about replication or data distribution inside the backend. This is a valid issue? Thanks, Gustavo.
    Gustavo ToniniGustavo Tonini
    Dec 5, 2005 at 7:38 pm
    Dec 10, 2005 at 10:26 am
  • Here is a test case for a previously reported bug (see http://archives.postgresql.org/pgsql-general/2005-11/msg01235.php): initdb using es_MX.ISO-8859-1, start postgres using es_MX.UTF-8 and execute: ...
    Manuel SugawaraManuel Sugawara
    Dec 20, 2005 at 3:51 am
    Dec 29, 2005 at 7:26 pm
  • Hi, At my work, I have to dump a database and restore it on another database under a specific schema. My first idea was to create the new schema on the old database, move all the database objects on ...
    Guillaume LELARGEGuillaume LELARGE
    Dec 10, 2005 at 8:47 am
    Dec 12, 2005 at 11:43 pm
  • Now that Oracle supports i18n dependant behavior in its to_char formatting functions (at least for its 10g release) I was wondering if a patch to support this in PostgreSQL will get accepted. I was ...
    Manuel SugawaraManuel Sugawara
    Dec 22, 2005 at 3:24 am
    Mar 3, 2006 at 6:40 am
  • I've just been bitten by the "backslash in string literals" issue. I have reviewed the mailing lists and the TODO list. I see that the direction PostgreSQL is headed is to drop the nonstandard ...
    Kevin GrittnerKevin Grittner
    Dec 8, 2005 at 5:14 pm
    Feb 13, 2006 at 5:25 pm
  • I've gotten interested again in the issue of row comparisons, eg (a, b, c) = (1, 2, 3) We've discussed this before, the most comprehensive thread being ...
    Tom LaneTom Lane
    Dec 23, 2005 at 8:18 pm
    Dec 28, 2005 at 7:22 pm
  • We have encountered a very nasty but apparently rare bug which appears to result in catalog corruption. I have not been able to pin down an exact sequence of events which cause this problem, it ...
    Jeremy DrakeJeremy Drake
    Dec 22, 2005 at 2:12 am
    Jan 9, 2006 at 7:41 pm
  • Hi! I would like to add an entry to PostgreSQL 8.2 TODO: - Extend SERIAL to a full-featured auto-incrementer type. To achieve this, the following three requirements should be fulfilled: 1. The ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Dec 3, 2005 at 9:24 pm
    Dec 7, 2005 at 1:18 pm
  • ... seems to be behaving oddly: dllwrap -o rainbow.dll --def rainbow.def rainbow.o c:/PROGRA~1/POSTGR~1/8.1/lib/pgxs/src/MAKEFI~1/../../src/utils/dllinit.o -Lc:/PROGRA~1/POSTGR~1/8.1/bin -lpostgres ...
    Andrew DunstanAndrew Dunstan
    Dec 21, 2005 at 5:44 pm
    Jan 19, 2006 at 12:48 pm
  • The discussion was a bit inconclusive last time, so I would like to renew my proposal for more generous default resource limits. Nearly everyone seems to agree that the default for max_fsm_pages is ...
    Andrew DunstanAndrew Dunstan
    Dec 12, 2005 at 2:46 pm
    Jan 2, 2006 at 4:49 pm
  • Hi, I need to log any statement in my postgresql server. However, I would like that the password defined in CREATE USER statement was registered in MD5 format, independent of the form as it was ...
    Ricardo Vaz - TCESPRicardo Vaz - TCESP
    Dec 9, 2005 at 1:35 pm
    Dec 18, 2005 at 2:32 pm
  • I found an interesting paper improving index speed by prefetching memory data to L1/L2 cache here (there is discussion about prefetching disk data to memory several days ago "ice-breaker thread"): ...
    Qingqing ZhouQingqing Zhou
    Dec 9, 2005 at 4:18 am
    Dec 11, 2005 at 12:47 am
  • Platypus (http://lnk.nu/pgbuildfarm.org/6yt.pl) started failing about 12 days ago with the following: ccache gcc -O3 -pipe -pipe -fno-strict-aliasing -g -Wall -Wmissing-prototypes ...
    Jim C. NasbyJim C. Nasby
    Dec 12, 2005 at 11:25 pm
    Dec 15, 2005 at 8:02 pm
  • I'm working on a project, whose implementation deals with PostgreSQL. A brief description of the project is given below. Project Description: -------------------- In Main Memory DataBase(MMDB) entire ...
    Anjan Kumar. A.Anjan Kumar. A.
    Dec 11, 2005 at 10:52 am
    Jan 16, 2006 at 12:20 am
  • Greetings everybody, As part of the changes I would like relating to collations, the two sort options in inlineApplySortFunction() using only a less-than operator may become unsupportable. This has ...
    Martijn van OosterhoutMartijn van Oosterhout
    Dec 28, 2005 at 10:06 pm
    Jan 1, 2006 at 5:56 pm
  • I noticed that we are using the term "Online Backup" in our documentation when we are talking about continuous backup and PITR. To me, "online backup" is doing a backup while the system is online ...
    Bruce MomjianBruce Momjian
    Dec 26, 2005 at 5:55 pm
    Dec 30, 2005 at 1:35 pm
  • We've suspected for awhile that once we'd fixed the buffer manager's use of a single global BufMgrLock, the next contention hotspot would be the lock manager's LockMgrLock. I've now seen actual ...
    Tom LaneTom Lane
    Dec 7, 2005 at 9:59 pm
    Dec 11, 2005 at 9:26 pm
  • Until recently, pg_relation_size used SearchSysCache to locate the relation to examine, and calculated the file location from that information. Starting with dbsize.c V1.5 (committed after Beta2), ...
    Andreas PflugAndreas Pflug
    Dec 12, 2005 at 11:32 am
    Dec 13, 2005 at 5:07 am
  • Does anyone else find this odd: mysql=# select extract(microseconds from timestamp '2005-01-01 00:00:00.123'); date_part ----------- 123000 (1 row) mysql=# select extract(microseconds from timestamp ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 6, 2005 at 3:39 pm
    Dec 7, 2005 at 3:37 pm
  • Hi all, I wrote a experimental patch for a vertical partitioning function. I decided to use the code of TOAST to create the function easily. In a word, the row that the user specified is forcedly ...
    Junji TERAMOTOJunji TERAMOTO
    Dec 1, 2005 at 12:07 pm
    Mar 4, 2006 at 7:15 pm
  • Hi, Is there any way to force COPY to accept that there will be lines of different length in a data file? I have a rather large file I'm trying to import. It's in CSV format, however, they leave off ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 12, 2005 at 4:17 am
    Dec 13, 2005 at 2:04 am
  • Hi everyone, I've been able to successfully build server extension using Visual Studio 2005 for Windows Postgresql 8.1. However, it took a few tweaks which I thought I should document (maybe these ...
    Charles F. I. SavageCharles F. I. Savage
    Dec 3, 2005 at 12:54 am
    Mar 5, 2006 at 4:45 am
  • platforms Both of them are modified versions of Bentley's sort algorithm. I just added the in-order check to both of them, and the reversed partition check for the second method (in the case of the ...
    Dann CorbitDann Corbit
    Dec 17, 2005 at 1:17 am
    Dec 22, 2005 at 10:21 pm
  • I've spent some time looking into how we can improve our planning of outer joins. The current planner code slavishly follows the syntactic join order, which can lead to quite bad plans. The reason it ...
    Tom LaneTom Lane
    Dec 15, 2005 at 2:27 am
    Dec 22, 2005 at 2:03 am
  • Comments, please -hackers? Which implementation should I pick (or another)? Best Regards, Simon Riggs
    Simon RiggsSimon Riggs
    Dec 8, 2005 at 11:10 am
    Mar 8, 2006 at 3:35 pm
  • When we discussed online REINDEX recently we focused on the REINDEX command itself rather than look at alternative approaches. One reason to REINDEX is because of index page splits getting things out ...
    Simon RiggsSimon Riggs
    Dec 22, 2005 at 12:00 am
    Dec 25, 2005 at 2:01 am
  • Anyone remember this patch? http://gorda.di.uminho.pt/community/pgsqlhooks/ The discussion seems to be pretty minimal: http://archives.postgresql.org/pgsql-hackers/2005-06/msg00859.php Does anyone ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 8, 2005 at 2:38 am
    Jan 3, 2006 at 7:15 pm
  • Hi, I have a query that previously worked fine using pg8 on Fedora. Since then we've moved to a FreeBSD 6 server running pg8.1.1 and the query doesn't seem to ever finish. I have VACUUM ANALYZEd the ...
    SebastianSebastian
    Dec 29, 2005 at 7:15 pm
    Dec 30, 2005 at 11:46 pm
  • Hi , Here is the requirements : 1. Development & Support team can ONLY have READ Only ACCESS to PRODUCTION Database. They will NOT have access to create stored procedure & functions in the PRODUCTION ...
    Ashok AgrawalAshok Agrawal
    Dec 22, 2005 at 11:11 pm
    Dec 27, 2005 at 9:44 pm
  • Folks, I've been looking into ways to have a better idea--automatically--of what's been going on in a database from a DDL level, and here's what I've come up with so far. I'd much appreciate hearing ...
    David FetterDavid Fetter
    Dec 14, 2005 at 3:55 am
    Dec 17, 2005 at 2:19 pm
  • The optimizer seems to want to use sequential scans on inherited tables when crossed with another table, as the following seems to demonstrate: Create Table base(f1 bigserial); create table inh1(f2 ...
    Philip WarnerPhilip Warner
    Dec 2, 2005 at 2:55 pm
    Dec 7, 2005 at 1:50 am
  • We have very strange behavior from an internal production database. There are multiple symptoms, all pointing to a problem with clusterwide tables. For example: postgres@csdfds1:~ psql -U postgres -p ...
    Joe ConwayJoe Conway
    Dec 2, 2005 at 11:44 pm
    Dec 3, 2005 at 3:33 am
  • Yea, I noticed the 0 was listed as another value that needs to be checked. Should I just change them all to: errno = 0; /* avoid checking result for failure */ or should I add a macro to c.h as: /* ...
    Bruce MomjianBruce Momjian
    Dec 1, 2005 at 9:00 pm
    Dec 2, 2005 at 2:49 am
  • Folks, Please find enclosed a patch that lets you use \c to connect (optionally) to a new host and port without exiting psql. Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 ...
    David FetterDavid Fetter
    Dec 9, 2005 at 9:10 am
    Dec 12, 2005 at 4:00 pm
  • [ Moved to hackers for patch discussion.] John D. Burger wrote: Good point, but I am not 100% sure on the limitation. Look at this: test= CREATE TABLE test(x NUMERIC); CREATE TABLE test= INSERT INTO ...
    Bruce MomjianBruce Momjian
    Dec 5, 2005 at 5:38 pm
    Dec 6, 2005 at 6:27 pm
  • Hi I am testing the durability of PostgreSQL. When a part of log was lost due to the trouble(power supply trouble etc.), I tested about the recovery of PostgreSQL. The loss of log was simulated by ...
    OKADA SatoshiOKADA Satoshi
    Dec 19, 2005 at 5:20 am
    Mar 27, 2006 at 3:26 pm
  • Examining why psql won't do sensible stuff with COPY BINARY, I realized that psql still uses PQgetline, which is marked obsolete since 7.4. Is this intentional or just a "never reviewed because it ...
    Andreas PflugAndreas Pflug
    Dec 14, 2005 at 11:31 am
    Dec 17, 2005 at 3:07 pm
  • Hi, I am trying to prove whether PostgreSQL is faster than Informix so I can feed the management with numbers. In our system, there is an invoice browser view, an UNION of 12 different tables. (Yes, ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Dec 14, 2005 at 3:40 pm
    Dec 15, 2005 at 10:26 pm
  • Folks, I'm trying to come up with a design for \ commands in psql in 8.2. 8.1 broke just about every \ command because they now depend on roles, which is great for 8.1 or better, but not so good if ...
    David FetterDavid Fetter
    Dec 14, 2005 at 9:52 am
    Dec 15, 2005 at 1:49 am
  • Anybody remembers my patch to allow tracking the minimum Xid present in a table, allowing to update the freeze xid on a per-table basis? The motivation behind it was to remove the requirement of ...
    Alvaro HerreraAlvaro Herrera
    Dec 9, 2005 at 4:32 pm
    Dec 10, 2005 at 3:03 pm
  • OK, I give up - how do I convert an INET type to a NUMERIC representation of its network address? Is there a quick and easy way? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 6, 2005 at 7:30 am
    Dec 6, 2005 at 8:15 am
  • Hello, as far as I have understood, the WAL backup that you control via "archive_command" is the PostgreSQL equivalent to what other databases let you do with an incremental backup. That is, if you ...
    Gregor ZeitlingerGregor Zeitlinger
    Dec 25, 2005 at 1:02 pm
    Jan 9, 2006 at 11:01 am
Group Navigation
period‹ prev | Dec 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions151
posts1,252
users136
websitepostgresql.org...
irc#postgresql

136 users for December 2005

Tom Lane: 250 posts Bruce Momjian: 106 posts Andrew Dunstan: 83 posts Simon Riggs: 56 posts Martijn van Oosterhout: 50 posts Christopher Kings-Lynne: 44 posts Qingqing Zhou: 44 posts Greg Stark: 37 posts Jim C. Nasby: 33 posts Alvaro Herrera: 29 posts Hannu Krosing: 23 posts Michael Fuhr: 17 posts Peter Eisentraut: 17 posts Jan Wieck: 16 posts Andreas Pflug: 14 posts Dann Corbit: 14 posts Dave Page: 14 posts Jim C. Nasby: 13 posts Joshua D. Drake: 13 posts Zoltan Boszormenyi: 12 posts
show more
Archives