FAQ

Search Discussions

188 discussions - 1,866 posts

  • I'm putting this out there before we publish a fix so that we can discuss how best to fix it. Doug and Sherry recently found the source of an important performance issue with the Postgres shared ...
    Luke LonerganLuke Lonergan
    Mar 4, 2007 at 7:11 pm
    Apr 2, 2007 at 11:16 pm
  • There are few things I realized over the weekend while going through the code: 1. It looks like a bad idea to use ALTER TABLE .. to chill a table becuase ALTER TABLE takes AccessExclusive lock on the ...
    Pavan DeolaseePavan Deolasee
    Mar 19, 2007 at 9:21 am
    Mar 31, 2007 at 4:04 am
  • Hi, I've a problem with a database, I can dump the database to a file, but restoration fails, happens with 8.1.4. Steps to reproduce: create database testdb with encoding='UTF8'; \c testdb create ...
    Mario WeilguniMario Weilguni
    Mar 13, 2007 at 11:01 am
    Jun 13, 2007 at 11:36 pm
  • I like macros. ;-) -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
    Bruce MomjianBruce Momjian
    Mar 31, 2007 at 11:13 pm
    May 11, 2007 at 11:58 pm
  • Hi, Here's an update of a code to improve full page writes as proposed in http://archives.postgresql.org/pgsql-hackers/2007-01/msg01491.php and ...
    Koichi SuzukiKoichi Suzuki
    Mar 27, 2007 at 3:13 am
    Sep 25, 2007 at 9:30 am
  • Hi, This is to get feedback to meet the following TODO: - Simplify ability to create partitioned tables This would allow creation of partitioned tables without requiring creation of rules for ...
    NikhilSNikhilS
    Mar 6, 2007 at 11:57 am
    Mar 12, 2007 at 3:14 pm
  • Hi, Was wondering if people would mind having a read over what I plan to do for my undergraduate honours project - you can get the proposal here: http://www.mcs.vuw.ac.nz/~eddie/489_Proposal.pdf What ...
    Edward StanleyEdward Stanley
    Mar 9, 2007 at 1:43 am
    Mar 17, 2007 at 12:44 pm
  • The current buildfarm webpages make it easy to see when a branch tip is seriously broken, but it's not very easy to investigate transient failures, such as a regression test race condition that only ...
    Tom LaneTom Lane
    Mar 16, 2007 at 7:11 pm
    Mar 20, 2007 at 7:16 pm
  • What is the safest way to access/modify the pg_class attribute and still avoid any race conditions with the other backends ? A specific example is: To solve the CREATE INDEX problem with HOT, I am ...
    Pavan DeolaseePavan Deolasee
    Mar 16, 2007 at 11:51 am
    Mar 23, 2007 at 2:22 am
  • I seem to remember that we'd agreed that autovacuum should ignore any globally set statement_timeout, on the grounds that a poorly chosen setting could indefinitely prevent large tables from being ...
    Tom LaneTom Lane
    Mar 30, 2007 at 4:15 am
    Mar 15, 2008 at 1:44 am
  • Right now, all the patches I think are ready for review are in the patch queue: http://momjian.postgresql.org/cgi-bin/pgpatches However, with feature freeze coming on Sunday, I am worried because ...
    Bruce MomjianBruce Momjian
    Mar 28, 2007 at 1:15 am
    Mar 29, 2007 at 6:14 pm
  • Is there a particular reason why CLUSTER isn't MVCC-safe? It seems to me that it would be trivial to fix, by using SnapshotAny instead of SnapshotNow, and not overwriting the xmin/xmax with the xid ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 9, 2007 at 11:29 am
    Mar 22, 2007 at 10:29 pm
  • I'm in a awkward situation right now. I've done my best to describe the use cases for clustered indexes. I know the patch needs refactoring, I've refrained from making API changes and tried to keep ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 14, 2007 at 10:22 am
    Mar 22, 2007 at 7:15 am
  • After thinking about this more I'm convinced that the above is a good idea, eg in heap_insert change if (HeapTupleHasExternal(tup) || tup- t_len TOAST_TUPLE_THRESHOLD) heaptup = ...
    Tom LaneTom Lane
    Mar 28, 2007 at 5:14 pm
    Apr 27, 2007 at 7:02 pm
  • Last try there was a fight about syntax of introduced commands. And we (Oleg and me) developed variant of patch with another syntax. We will not change docs until agreement will be reached, current ...
    Teodor SigaevTeodor Sigaev
    Mar 15, 2007 at 4:18 pm
    Mar 26, 2007 at 7:10 pm
  • We at International Institute of Information Technology (IIIT) Hyderabad, India, have extended the Postgres database system with the skyline operation. For this work, we were guided by our Prof. ...
    Ranbeer makinRanbeer makin
    Mar 3, 2007 at 1:32 pm
    Mar 12, 2007 at 3:45 am
  • I'm new to PostgreSQL, having done a little work with MySQL in the past. Part of the reason for changing to PostgreSQL is some of the differences but to understand them I need docs of course. Now ...
    Hugh SasseHugh Sasse
    Mar 23, 2007 at 2:15 pm
    Mar 25, 2007 at 12:02 am
  • Hi there I am trying to modify the execution of the table function to work in iterator fashion instead of materializing the output. I have been digging the Postgresql code source for about a month ...
    Islam HegazyIslam Hegazy
    Mar 18, 2007 at 7:55 pm
    Mar 20, 2007 at 9:06 pm
  • This feature (ability to add a message payload to a NOTIFY) is on the TODO list and I had undertaken to implement it. However, pressure of other work has conspired to make that difficult, and Abhijit ...
    Andrew DunstanAndrew Dunstan
    Mar 26, 2007 at 3:30 pm
    Dec 17, 2008 at 2:29 pm
  • Hi, I am right now working on to get HOT and VACUUM FULL work together. I hit upon a bug which I initially thought is something that HOT has introduced. But I can reproduce it with CVS HEAD as well. ...
    Pavan DeolaseePavan Deolasee
    Mar 7, 2007 at 6:17 pm
    Mar 14, 2007 at 2:58 pm
  • It's been known for years that commit_delay isn't very good at giving us group commit behavior. I did some experiments with this simple test case: "BEGIN; INSERT INTO test VALUES (1); COMMIT;", with ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 26, 2007 at 10:39 am
    Mar 7, 2008 at 4:09 am
  • In some of our applications, we have cases where it would be very nice if we could activate TOAST at some sort of lower threshold than the usual 2K that is true now. Let me note the current code that ...
    Chris BrowneChris Browne
    Mar 21, 2007 at 4:44 pm
    Apr 12, 2007 at 9:19 pm
  • Attatched you'll find a patch that I've been kicking around for a while that I'd like to propose for inclusion in 8.3. I attempted to submit this through the original xml2 author (as far back as the ...
    Mike RylanderMike Rylander
    Mar 5, 2007 at 10:25 pm
    Jun 1, 2007 at 7:33 pm
  • Reviewing earlier threads, I realised that there was a potential bug/loophole in PITR backups in conjunction with avoiding WAL for bulk operations. This would be rare, but should be fixed. ...
    Simon RiggsSimon Riggs
    Mar 9, 2007 at 1:58 pm
    May 16, 2007 at 12:47 am
  • It appears that we didn't do enough research in regards to the recent DST switch. We poorly assumed that having our machine's timezone files up to date would be sufficient not knowing that our ...
    Michael LedfordMichael Ledford
    Mar 13, 2007 at 4:20 pm
    Mar 14, 2007 at 3:36 pm
  • I have a problem getting packed varlenas to work with GIST indexes. Namely, the GIST code doesn't call pg_detoast_datum() enough. Instead of using the DatumGetFoo() macros it uses DatumGetPointer() ...
    Gregory StarkGregory Stark
    Mar 2, 2007 at 4:23 pm
    Mar 7, 2007 at 4:19 pm
  • FYI, I see the following warnings compiling CVS HEAD: src/pl/plpython/plpython.c:2006: warning: initialization from incompatible pointer type src/pl/plpython/plpython.c:2008: warning: 'intargfunc' is ...
    Neil ConwayNeil Conway
    Mar 3, 2007 at 7:15 pm
    Apr 4, 2007 at 5:28 pm
  • I have added to the developer's FAQ that we don't want non-BSD-compatible licensed patches: <li PostgreSQL is licensed under a BSD license. By posting a patch to the public PostgreSQL mailling lists, ...
    Bruce MomjianBruce Momjian
    Mar 2, 2007 at 5:52 pm
    Mar 19, 2007 at 4:53 pm
  • Hello, I'd like to work on TODO item: could you please tell me if I'm going in the right way? There are some different syntaxes possible, but MySQL has an interesting one here: ...
    Jonathan ScherJonathan Scher
    Mar 2, 2007 at 1:59 pm
    Mar 4, 2007 at 3:50 pm
  • Hello, PostgreSQL suppots SJIS, BIG5, GBK, UHC and GB18030 as client encodings, but we cannot use them as server encodings. Are there any reason for it? AFAICS, we can support them only if we add ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Mar 26, 2007 at 1:39 am
    Jun 25, 2007 at 4:10 am
  • It seems possible to reduce overall WAL volume by roughly 25% on common workloads by optimising the way UPDATE statements generate WAL. I've got a practical proposal that looks like it can be ...
    Simon RiggsSimon Riggs
    Mar 27, 2007 at 7:04 pm
    Mar 28, 2007 at 5:32 pm
  • CVS HEAD doc won't compile due to broken mark up. Please someone commit following patches if they are appropreate. Also please do not commit broken sgml files without trying to compile them. -- ...
    Tatsuo IshiiTatsuo Ishii
    Mar 2, 2007 at 5:31 am
    Aug 31, 2007 at 4:06 am
  • While cleaning up some pg_migrator code (http://pgfoundry.org/projects/pg-migrator/) it occurred to me that a typical libpq client application spends a lot of code constructing SQL commands. The code ...
    KorrydKorryd
    Mar 31, 2007 at 12:07 am
    Apr 5, 2007 at 1:55 pm
  • I know the idea has come up a few times to do cross-column statistics to improve plans when the data distributions are dependent. I found a couple references in the archives: ...
    Jeff DavisJeff Davis
    Mar 20, 2007 at 12:56 am
    Mar 21, 2007 at 9:47 am
  • Hello, I ran into an interesting problem with a customer today. They are running Jabber XCP (not the one we use). Unfortunately, the product has a bug that causes it to leave connections persistent ...
    Joshua D. DrakeJoshua D. Drake
    Mar 29, 2007 at 8:39 pm
    Apr 3, 2007 at 6:34 am
  • Hi, I would like to propose adding new character set "JIS X 0213"(http://en.wikipedia.org/wiki/JIS_X_0213). JIS X 0213 is a relatively new Japanese goverment standard (defined in 2000, revised in ...
    Tatsuo IshiiTatsuo Ishii
    Mar 22, 2007 at 4:05 am
    Apr 2, 2007 at 7:21 pm
  • Here is a low-level, very detailed description of the implementation of the autovacuum ideas we have so far. launcher's dealing with databases --------------------------------- We'll add a new member ...
    Alvaro HerreraAlvaro Herrera
    Mar 9, 2007 at 10:38 pm
    Mar 14, 2007 at 3:39 pm
  • Hi, I would like to be able to harden the conditions of generating IDENTITY columns so the events below run in this order: - assign values for regular columns (with or without DEFAULT) - NOT NULL ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Mar 1, 2007 at 5:04 am
    Mar 3, 2007 at 12:45 am
  • Use case for VACUUM FULL is very low these days. VACUUM does the most important part of what VACUUM FULL offers, yet does it concurrently rather than with a full table lock. VACUUM FULL also - has ...
    Simon RiggsSimon Riggs
    Mar 1, 2007 at 12:05 pm
    Mar 2, 2007 at 3:36 am
  • Here is a surprising article about how Oracle has made open source projects, like PostgreSQL, safe from claims of infringing Oracle patents: ...
    Bruce MomjianBruce Momjian
    Mar 30, 2007 at 4:44 pm
    Apr 4, 2007 at 2:57 am
  • Hello, The money type is considered deprecated. I was also under the impression it would be eventually removed. Why are we accumulating TODOs for it? # -Make 64-bit version of the MONEY data type # ...
    Joshua D. DrakeJoshua D. Drake
    Mar 20, 2007 at 6:23 pm
    Mar 21, 2007 at 4:29 pm
  • Hi All, Here are some preliminary numbers with the HOT 4.0 patch that I sent out earlier today. These are only indicative results and should not be used to judge the performance of HOT in general. I ...
    Pavan DeolaseePavan Deolasee
    Mar 1, 2007 at 1:49 pm
    Mar 2, 2007 at 10:50 pm
  • Isn't CREATE INDEX CONCURRENTLY prone deadlock conditions ? I saw one with VACUUM today. But I think it can happen with other commands like VACUUM FULL, CLUSTER, CREATE INDEX CONCURRENTLY and so on. ...
    Pavan DeolaseePavan Deolasee
    Mar 31, 2007 at 12:16 pm
    Mar 17, 2008 at 4:31 pm
  • I've updated the GIT patch at http://community.enterprisedb.com/git/. Bitrot caused by the findinsertloc-patch has been fixed, making that part of the GIT patch a little bit smaller and cleaner. I ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 7, 2007 at 10:32 am
    Apr 2, 2007 at 10:25 pm
  • Hello, We have had several customers get bit by the 8.2.3 stats collector bug. It is also starting to get reported in areas such as IRC. The really bad thing about this bug is that you won't know ...
    Joshua D. DrakeJoshua D. Drake
    Mar 24, 2007 at 12:54 am
    Mar 26, 2007 at 10:31 pm
  • Hi all, I'm observing this behavior in 8.2: kalman=# create table test ( a integer, b integer ); CREATE TABLE kalman=# kalman=# CREATE OR REPLACE FUNCTION sp_test ( INTEGER ) kalman-# RETURNS INTEGER ...
    Gaetano MendolaGaetano Mendola
    Mar 6, 2007 at 3:58 pm
    Mar 12, 2007 at 1:01 pm
  • While experimenting with the proposed CREATE INDEX support with HOT, I realized that SI invalidation are not sent properly for pg_index updates. I noticed the following comment in relcache.c /* * ...
    Pavan DeolaseePavan Deolasee
    Mar 26, 2007 at 5:27 pm
    May 2, 2007 at 9:13 pm
  • Hi, I have coded up a patch which solves the following TODO. I will submit a patch for this soon: - UPDATE - Allow UPDATE tab SET ROW (col, ...) = (SELECT...) ...
    NikhilSNikhilS
    Mar 15, 2007 at 6:06 am
    Apr 11, 2007 at 9:04 am
  • Hackers, I want to propose some very simple changes to autovacuum in order to move forward (a bit): 1. autovacuum_naptime semantics 2. limiting the number of workers: global, per database, per ...
    Alvaro HerreraAlvaro Herrera
    Mar 7, 2007 at 11:00 pm
    Mar 9, 2007 at 12:49 pm
  • Hi All, The version 4.0 of HOT patch is very close to the state where we can start considering it for testing for correctness as well as benchmarking, if there is sufficient interest to give it a ...
    Pavan DeolaseePavan Deolasee
    Mar 2, 2007 at 11:05 am
    Mar 5, 2007 at 8:46 pm
Group Navigation
period‹ prev | Mar 2007 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions188
posts1,866
users170
websitepostgresql.org...
irc#postgresql

170 users for March 2007

Tom Lane: 304 posts Simon Riggs: 113 posts Bruce Momjian: 102 posts Andrew Dunstan: 100 posts Joshua D. Drake: 93 posts Stark: 77 posts Heikki Linnakangas: 61 posts Alvaro Herrera: 45 posts Florian G. Pflug: 43 posts Josh Berkus: 40 posts Pavan Deolasee: 40 posts Luke Lonergan: 34 posts Magnus Hagander: 32 posts Jeff Davis: 30 posts Hannu Krosing: 29 posts Martijn van Oosterhout: 28 posts Pavan Deolasee: 26 posts Grzegorz Jaskiewicz: 24 posts NikhilS: 24 posts David Fetter: 23 posts
show more
Archives