FAQ

Search Discussions

155 discussions - 2,011 posts

  • Breaking down of patch into sections works very well for review. Should allow us to get different reviewers on different parts of the code - review wranglers please take note: Dave, Josh. Can you ...
    Simon RiggsSimon Riggs
    Dec 1, 2008 at 11:41 am
    Dec 24, 2008 at 6:36 pm
  • There are no explicit reasons. I thought it was natural, as if we can build Linux kernel without any enhanced security features (SELinux, SMACK and so on). I don't oppose to elimination of ...
    KaiGai KoheiKaiGai Kohei
    Dec 4, 2008 at 5:02 am
    Dec 15, 2008 at 1:00 am
  • Sorry for top posting but we are getting a bit far afield from the original topic. I followed up the tests I did last night: http://archives.postgresql.org/pgsql-hackers/2008-12/msg00369.php I ...
    Robert HaasRobert Haas
    Dec 6, 2008 at 6:19 pm
    Apr 3, 2009 at 2:26 am
  • Latest version of rmgr hooks patch for later review in current commitfest. (Minor update to CVS HEAD). -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
    Simon RiggsSimon Riggs
    Dec 17, 2008 at 7:24 pm
    Jan 24, 2009 at 7:51 pm
  • Currently SIGINT is ignored during <IDLE in transaction, but we have recently agreed to allow this to cancel the transaction. We said we would do this in all cases, so this is a separate ...
    Simon RiggsSimon Riggs
    Dec 17, 2008 at 3:31 pm
    Jan 13, 2010 at 1:44 pm
  • Whenever a B-tree index scan fetches a heap tuple that turns out to be dead, the B-tree item is marked as killed by calling _bt_killitems. When the page gets full, all the killed items are removed by ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 19, 2008 at 8:49 am
    Jan 13, 2009 at 7:06 pm
  • Hi, Sometimes people would like to call C++ code in the PostgreSQL backend environment... for example, in user-defined functions, triggers, access methods. And there is sometimes a need for C++ code ...
    Kurt HarrimanKurt Harriman
    Dec 5, 2008 at 8:27 am
    Jul 16, 2009 at 2:48 pm
  • As I've understood limitations of the PostgreSQL implementation of SERIALIZABLE transactions, at least the only example given in the documentation, revolve around a rather unlikely situation: Given ...
    Kevin GrittnerKevin Grittner
    Dec 22, 2008 at 5:01 pm
    Jan 22, 2009 at 3:00 am
  • Here is an update version of contrib/pg_stat_statements. New modifications from the last version are: 1. New counters in struct Instrumentation. 2. EXPLAIN ANALYZE VERBOSE shows buffer statistics in ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Dec 2, 2008 at 9:35 am
    Jan 5, 2009 at 5:01 pm
  • http://wiki.postgresql.org/wiki/Hot_Standby now contains a link to latest version of this patch. This is still at "v5", just brought forward to CVS HEAD. I will be doing further work on the patch ...
    Simon RiggsSimon Riggs
    Dec 17, 2008 at 3:21 pm
    Jan 14, 2009 at 8:10 am
  • Gregory StarkGregory Stark
    Dec 9, 2008 at 2:57 pm
    Jan 28, 2009 at 12:56 pm
  • Hi all, cvs head configured without --enable-debug hang in initdb while making check. warthog doesn't exhibit it because it's configured with debug. when it hangs, postmaster takes 100% cpu doing ...
    OhpOhp
    Dec 2, 2008 at 3:32 pm
    Dec 14, 2008 at 4:43 pm
  • Attached is the latest parallel restore patch. I think this is getting fairly close. Includes help text, docco and some extra error checking. cheers andrew
    Andrew DunstanAndrew Dunstan
    Dec 29, 2008 at 11:42 pm
    Mar 28, 2009 at 2:02 am
  • Hi Teodor Sigaev, I am getting server crash in contrib regression. May be I am doing something wrong here. Regression diff is attached. BTW these queries work fine outside the regression. -- Ibrar ...
    Ibrar AhmedIbrar Ahmed
    Dec 17, 2008 at 6:24 pm
    Apr 4, 2009 at 10:25 pm
  • The core window-functions patch is now committed and ready for wider testing. However, there are a number of unfinished items, at least some of which I'd like to see addressed before 8.4 release. In ...
    Tom LaneTom Lane
    Dec 28, 2008 at 7:26 pm
    Feb 5, 2009 at 4:35 am
  • Hi, just out of curiosity, why TRUNCATE doesn't support ONLY? audit=# TRUNCATE only postgres_log; ERROR: syntax error at or near "only" LINE 1: TRUNCATE only postgres_log; -- Atentamente, Jaime ...
    Jaime CasanovaJaime Casanova
    Dec 22, 2008 at 3:09 am
    Jan 21, 2009 at 2:29 pm
  • Hot Standby won't work with hash indexes because they are non-recoverable. We have a number of ways of dealing with this: 1. Workaround: Implement WAL for hash indexes 2. Specific Solution: make ...
    Simon RiggsSimon Riggs
    Dec 17, 2008 at 9:26 pm
    Dec 18, 2008 at 2:58 pm
  • Dear PostgreSQL developers, I am re-sending this to keep this last change to the internal hash function on the radar. Ken ............ Sorry about the delay for this update to the new hash index ...
    Kenneth MarshallKenneth Marshall
    Dec 22, 2008 at 7:47 pm
    Oct 29, 2009 at 4:59 pm
  • I've been looking at the signal handling part of the synchronous replication patch. It looks OK, but one thing makes me worry. To set or clear the flag from PGPROC, to send or handle a signal, we ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 8, 2008 at 8:04 am
    Jan 13, 2009 at 9:03 am
  • Hi, Here's a patch for improving the general reloptions mechanism. What this patch does is add a table-based option parser. This allows adding new options very easily, and stops the business of ...
    Alvaro HerreraAlvaro Herrera
    Dec 19, 2008 at 9:55 pm
    Jan 5, 2009 at 2:26 pm
  • The way VACUUM works with the visibility map is that if any pages are skipped, relfrozenxid can't be updated. That means that plain VACUUM won't advance relfrozenxid, and doesn't protect from XID ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 17, 2008 at 9:40 am
    Jan 22, 2009 at 7:28 pm
  • /* * We don't need to lock the page, as we're only looking at a single bit. */ result = (map[mapByte] & (1 << mapBit)) ? true : false; Isn't this a dangerous assumption to make ? I am not so sure ...
    Pavan DeolaseePavan Deolasee
    Dec 5, 2008 at 7:10 am
    Jan 20, 2009 at 5:09 pm
  • Oh, and another thing --- should variadic parameters be defaultable? The current patch doesn't allow it but it looks more like an oversight than anything that was thought through. The boundary case ...
    Tom LaneTom Lane
    Dec 17, 2008 at 12:07 am
    Dec 18, 2008 at 9:49 am
  • OK, after quite some trying I have hit a brick wall. I have been unable to get parallel restore to work with Windows threading. No doubt I am missing something, but I really don't know what. Unless ...
    Andrew DunstanAndrew Dunstan
    Dec 9, 2008 at 2:08 am
    Dec 24, 2008 at 10:58 pm
  • I would like to have this clarified, as I keep running afoul of it. We originally did the Windows port using the MinGW build system because we did not want to maintain another build system. When ...
    Peter EisentrautPeter Eisentraut
    Dec 20, 2008 at 3:27 pm
    Dec 31, 2008 at 11:51 pm
  • ISTM that the PD_ALL_VISIBLE flag and the visibility map bit can be set at the end of pruning operation if we know that there are only tuples visible to all transactions left in the page. The way ...
    Pavan DeolaseePavan Deolasee
    Dec 5, 2008 at 6:57 am
    Feb 27, 2010 at 2:40 pm
  • It seems this is a pile of pretty useless code, so far as the core distribution is concerned, unless somebody fixes dblink to use it. Is that on anyone's radar for 8.4? regards, tom lane
    Tom LaneTom Lane
    Dec 20, 2008 at 5:33 pm
    Jan 7, 2009 at 1:05 pm
  • It has been pointed out to me that the output of the version() function is becoming more confusing in face of mixed 32/64 bit environments. Output like i486-pc-linux-gnu just says what kind of kernel ...
    Peter EisentrautPeter Eisentraut
    Dec 30, 2008 at 8:42 am
    Jan 7, 2009 at 9:46 am
  • The attached patch contains a couple of fixes in the existing probes and includes a few new ones. - Fixed compilation errors on OS X for probes that use typedefs - Fixed a number of probes to pass ...
    Robert LorRobert Lor
    Dec 15, 2008 at 1:36 pm
    Dec 24, 2008 at 8:41 pm
  • Consider create function foo(f1 int, f2 int = 42, f2 int = 43) ... create view v1 as select foo(11); In CVS HEAD this gives regression=# \d v1 View "public.v1" Column | Type | Modifiers ...
    Tom LaneTom Lane
    Dec 16, 2008 at 8:25 pm
    Dec 18, 2008 at 10:14 am
  • I like strict in general, but this doesn't seem logical: postgres=# SELECT to_timestamp('29-12-2005 01:2:03', 'DD-MM-YYYY HH24:MI:SS'); -- works to_timestamp ------------------------ 2005-12-29 ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 1, 2008 at 12:08 pm
    Dec 2, 2008 at 8:19 am
  • Hi, Pgsql-hackers. We would like to obtain your opinion on these two questions: 1) We wanna append possibilities into Postgres engine, and wanna get top estimation for size of code, cost and time of ...
    Dmitry TurinDmitry Turin
    Dec 11, 2008 at 9:43 am
    Dec 11, 2008 at 4:21 pm
  • Hi All, Following test returns error on 8.4 cvs head. it looks like an issue Testcase: (8.4 CVS head) ==================== CREATE OR REPLACE FUNCTION f007( a INTEGER, b INTEGER DEFAULT 10 ) RETURNS ...
    Rushabh LathiaRushabh Lathia
    Dec 15, 2008 at 9:04 am
    Dec 19, 2008 at 4:15 am
  • Hello. I can successfully ALTER a NON-EMPTY table (ct) which ROWTYPE is used as a column type for another table (dt): CREATE TABLE ct (id INTEGER); CREATE TABLE dt (id INTEGER, c ct); INSERT INTO dt ...
    Dmitry KoterovDmitry Koterov
    Dec 4, 2008 at 2:58 pm
    Dec 10, 2008 at 2:47 pm
  • Since this whole in-place upgrade thing is going nowhere until there's also a good solution for ye olde "The database cluster was initialized with CATALOG_VERSION_NO ..." error, I spent some time ...
    Greg SmithGreg Smith
    Dec 3, 2008 at 7:22 am
    Dec 5, 2008 at 12:15 pm
  • Who anyone be opposed to "ssldir = path" as a connection option? Currently, there is no way to change the homedir method ~/.postgresql ... or am I missing something? I am willing to supply a patch. ...
    Andrew ChernowAndrew Chernow
    Dec 5, 2008 at 8:59 pm
    Jan 7, 2009 at 12:03 pm
  • Right now we don't allow setting reloptions to toast tables: =# alter table pg_toast.pg_toast_16395 set (fillfactor = 40); ERROR: "pg_toast_16395" is not a table or index However this is needed for ...
    Alvaro HerreraAlvaro Herrera
    Dec 20, 2008 at 11:01 pm
    Jan 7, 2009 at 11:50 pm
  • The window functions patch is laboring under the delusion that it can call an aggregate's final function and then go back to invoking the transfn some more on the same data. This is merest fantasy ...
    Tom LaneTom Lane
    Dec 24, 2008 at 3:20 am
    Dec 27, 2008 at 1:57 pm
  • Hi, I posted a patch 18 days ago but have got no responce. Anyway I've simplified the patch by using an appropriate gettext module. Hiroshi Inoue wrote: AFAICS there are 2 causes. 1. MSVC version of ...
    Hiroshi InoueHiroshi Inoue
    Dec 26, 2008 at 2:48 pm
    Jan 21, 2009 at 11:36 am
  • I'm still casting about to make sure I have my head around the issues adequately to suggest a documentation update. Here's my current understanding. The below is intended to help define the nature ...
    Kevin GrittnerKevin Grittner
    Dec 30, 2008 at 12:14 am
    Jan 6, 2009 at 5:17 pm
  • While watching WAL records float by I noticed some AccessExclusiveLocks occurring unnecessarily during VACUUMs. This is caused by lines 186-189 in lazy_vacuum_rel(), vacuumlazy.c possibly_freeable = ...
    Simon RiggsSimon Riggs
    Dec 31, 2008 at 6:20 pm
    Jan 6, 2009 at 3:16 pm
  • As far as I have understood the following query SELECT DISTINCT foo FROM bar LIMIT baz is done by first sorting the input and then traversing the sorted data, ensuring uniqueness of output and ...
    TmpTmp
    Dec 4, 2008 at 1:43 pm
    Dec 16, 2008 at 9:15 pm
  • Hi, I'm wondering if following behavior of PostgreSQL regarding lock conflict is an expected one. Here's a scenario: Session A: BEGIN; SELECT * FROM pg_class limit 1; -- acquires access share lock ...
    Tatsuo IshiiTatsuo Ishii
    Dec 22, 2008 at 8:14 am
    Jan 22, 2009 at 11:28 pm
  • Hi, i'm seeing a fail in the rules regression, seems like it is not ordering the results right even when the regression has an explicit order by... i'm in a mingw32 5.1 on xp sp2 using msys 1.0.10 ...
    Jaime CasanovaJaime Casanova
    Dec 15, 2008 at 1:44 pm
    Dec 22, 2008 at 12:22 am
  • create table a(a int not null); insert into a(a) select generate_series(1,6000000); create table b as select * from a where a%10 < 0; create index fooa on a(a); alter table b alter column a set not ...
    Grzegorz JaskiewiczGrzegorz Jaskiewicz
    Dec 18, 2008 at 5:15 pm
    Dec 19, 2008 at 2:51 pm
  • Hi all, I have put a first draft of the wiki page dedicated to the table partitioning development at http://wiki.postgresql.org/wiki/Table_partitioning The page is still incomplete and need much more ...
    Emmanuel CecchetEmmanuel Cecchet
    Dec 17, 2008 at 2:48 am
    Dec 18, 2008 at 1:41 pm
  • Could anyone with a MinGW system please run the ecpg regression suite including tcp checks for the current CVS HEAD for me? Just run "make checktcp" in src/interfaces/ecpg and afterwards send me the ...
    Michael MeskesMichael Meskes
    Dec 1, 2008 at 11:42 am
    Dec 18, 2008 at 3:02 am
  • Looking for a way to limited a user to a specific set of queries. I don't think this can be done right now ... or can it? Has this feature request surfaced in the past? I currently need this as an ...
    Andrew ChernowAndrew Chernow
    Dec 6, 2008 at 6:22 pm
    Dec 8, 2008 at 3:29 pm
  • According to SQL2008 section 7.11 <window clause , general rule 5, the default definition of window framing in a window that has an ordering clause but no framing (RANGE/ROWS) clause is that the ...
    Tom LaneTom Lane
    Dec 26, 2008 at 9:04 pm
    Jan 22, 2009 at 11:13 pm
  • Hello, I did small tests and I found so for small tables (less 1000 rows) VACUUM based on visibility maps are slower than old implementation it is about 5ms X 20ms Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Dec 8, 2008 at 12:31 pm
    Jan 20, 2009 at 5:32 pm
Group Navigation
period‹ prev | Dec 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions155
posts2,011
users131
websitepostgresql.org...
irc#postgresql

131 users for December 2008

Tom Lane: 278 posts Simon Riggs: 139 posts Heikki Linnakangas: 104 posts Robert Haas: 95 posts Bruce Momjian: 93 posts Alvaro Herrera: 81 posts Greg Stark: 76 posts Peter Eisentraut: 75 posts Fujii Masao: 66 posts Pavel Stehule: 56 posts Kevin Grittner: 45 posts Magnus Hagander: 42 posts Andrew Dunstan: 37 posts Greg Smith: 35 posts Hitoshi Harada: 34 posts KaiGai Kohei: 34 posts Pavan Deolasee: 29 posts KaiGai Kohei: 27 posts Jeff Davis: 25 posts Greg Stark: 23 posts
show more
Archives