FAQ

PostgreSQL > pgsql-hackers > January 2008

Search Discussions

134 discussions - 1,219 posts

  • It sure would be nice to have this in core. Yeah, there's pgcrypto, but it's a bit overkill for people who simply want to do a SHA1, especially when they see we already have a md5(). I also realize ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jan 20, 2008 at 5:23 pm
    Apr 6, 2008 at 6:29 pm
  • Happy New Year, everybody. This proposal follows on from previous thinking about partitioning, where I've taken up Andrew Sullivan's suggestion to re-examine the current partitioning concept of using ...
    Simon RiggsSimon Riggs
    Jan 2, 2008 at 5:55 pm
    Jan 12, 2008 at 1:53 am
  • [ redirecting thread to -hackers ] Neil Conway <neilc@samurai.com writes: We have enable_seqscan already, so that last choice seems to fit in. regards, tom lane
    Tom LaneTom Lane
    Jan 28, 2008 at 2:04 am
    Feb 5, 2008 at 7:46 pm
  • Dear Friends, In my past development projects, I always used the concept of Materialized VIEW to speed-up SELECTs over INSERTs. You are well aware of Jonathan Gardner preliminary work: ...
    Jean-Michel PouréJean-Michel Pouré
    Jan 12, 2008 at 12:27 pm
    Jan 17, 2008 at 11:31 am
  • Hi all, Many of you will have read the dynamic partitioning thread here: http://archives.postgresql.org/pgsql-hackers/2008-01/msg00028.php I've proposed an alternative approach, which we've called ...
    Gavin SherryGavin Sherry
    Jan 11, 2008 at 11:13 pm
    Jan 20, 2008 at 12:57 pm
  • (for 8.4 ...) I'd like to introduce triggers that fire when we issue a truncate: CREATE TRIGGER name [BEFORE | AFTER ] TRUNCATE ON table FOR EACH STATEMENT EXECUTE PROCEDURE function (arguments); The ...
    Simon RiggsSimon Riggs
    Jan 25, 2008 at 11:39 am
    Feb 11, 2008 at 5:39 pm
  • Using the attached patch, SSL will act over Unix-domain sockets. AFAICT, this just works. I didn't find a way to sniff a Unix-domain socket, however. How should we proceed with this? -- Peter ...
    Peter EisentrautPeter Eisentraut
    Jan 4, 2008 at 4:13 pm
    Jan 17, 2008 at 1:44 pm
  • Hi, May be i am reposting something which has been discussed to end in this forum. I have made a search in the archives and i couldn't find any immediately. With my relatively small experience in ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Jan 9, 2008 at 10:39 am
    Jan 16, 2008 at 9:21 pm
  • Further poking around shows that the "unrecognized locktag" is because lmgr.c:DescribeLockTag was never taught about virtual xids. Ie something like this (untested): --- lmgr.c 04 Jan 2008 15:12:37 ...
    Gregory StarkGregory Stark
    Jan 7, 2008 at 4:21 pm
    Jan 15, 2008 at 7:24 pm
  • Now that we have a txid_snapshot datatype, it seems easy to imagine that we might use that to pass snapshot information around between sessions. If we had a function ...
    Simon RiggsSimon Riggs
    Jan 11, 2008 at 4:14 pm
    Mar 28, 2008 at 6:57 pm
  • There was a serious performance regression in OUTER JOIN planning going from 8.2.4 to 8.2.5. I know Tom came up with some patches to mitigate the issues in 8.2.5, but my testing shows that problems ...
    Kevin GrittnerKevin Grittner
    Jan 4, 2008 at 6:16 pm
    Jan 17, 2008 at 10:25 pm
  • After chewing on this for awhile, it seems to me that pg_aggregate.c is using enforce_generic_type_consistency() in a rather fundamentally different way than it's being used anywhere else. Everywhere ...
    Tom LaneTom Lane
    Jan 6, 2008 at 7:45 pm
    Jan 11, 2008 at 6:43 pm
  • I really needed this functionality in PostgreSQL. A common use for autonomous transactions is error logging. I want to log sqlerrm in a function and raise an exception so the calling application ...
    Roberts, JonRoberts, Jon
    Jan 22, 2008 at 4:03 pm
    Jan 30, 2008 at 5:12 pm
  • Hello I found so PL/SQL support CASE statement http://download-east.oracle.com/docs/cd/B10500_01/appdev.920/a96624/04_struc.htm#484 I propose add this statement to PL/pgSQL too. Reasons: a) it's ...
    Pavel StehulePavel Stehule
    Jan 17, 2008 at 3:01 pm
    Mar 28, 2008 at 3:30 am
  • http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=mastodon&dt=2008-01-30%2020:00:00 /D
    Dave PageDave Page
    Jan 30, 2008 at 8:29 pm
    Jan 31, 2008 at 4:28 pm
  • It occurred to me the other day that synchronized scans could play havoc with clustered tables. When you dump and reload a table even if it was recently clustered if any other sequential scans are ...
    Gregory StarkGregory Stark
    Jan 27, 2008 at 3:02 pm
    Jan 28, 2008 at 10:45 pm
  • Here (@sophos.com) we run machine cluster tests using FreeBSD jails. A jail is halfway between a chroot and a VM. Jails blow a number of assumptions about a unix environment: sysv ipc's are global to ...
    Mischa SandbergMischa Sandberg
    Jan 16, 2008 at 4:41 pm
    May 8, 2008 at 2:24 am
  • Hello, I spent the better part of this evening tracking down a problem with a high velocity database. The database had entered the point of no return by invoking xidStopLimit. This by itself isn't a ...
    Joshua D. DrakeJoshua D. Drake
    Jan 6, 2008 at 8:37 am
    Jan 14, 2008 at 11:48 pm
  • Hello, Table "pg_catalog.pg_autovacuum" Column | Type | Modifiers - ------------------+---------+----------- vacrelid | oid | not null enabled | boolean | not null vac_base_thresh | integer | not ...
    Joshua D. DrakeJoshua D. Drake
    Jan 17, 2008 at 9:16 pm
    Mar 7, 2008 at 7:04 pm
  • When we split an index page we perform a multi-block operation that is both fairly expensive and complex to reconstruct should we crash partway through. If we could log *only* the insert that caused ...
    Simon RiggsSimon Riggs
    Jan 1, 2008 at 1:06 pm
    Jan 8, 2008 at 7:06 am
  • On Oracle: SQL select to_date('31-DEC-200700:00:00', 'dd-mon-yyyy hh24:mi:ss') from dual; TO_DATE(' --------- 31-DEC-07 On PostgreSQL: select to_date('31-DEC-200700:00:00', 'dd-mon-yyyy hh24:mi:ss'); ...
    Peter EisentrautPeter Eisentraut
    Jan 10, 2008 at 12:41 pm
    Jan 17, 2008 at 9:16 am
  • Hi, IMO, the lengthy discussion about Segment Exclusion and Segment Visibility Maps has long turned into a discussion about partitioning in general. I'm thankful for all the new insights it has ...
    Markus SchiltknechtMarkus Schiltknecht
    Jan 8, 2008 at 7:08 pm
    Jan 10, 2008 at 10:21 am
  • I suggest one more standard date/time operator, to divide one interval by another with numeric (or float, for example) result. I.e. something like that: database=# SELECT '5400 seconds'::interval / ...
    Ilya A. KovalenkoIlya A. Kovalenko
    Jan 9, 2008 at 10:34 am
    Jan 10, 2008 at 7:25 am
  • Some thought about bug #3847 led me to the following test case: create table t1(f1 int); create or replace function t1trig() returns trigger as $$ begin raise notice 'f1 = %', new.f1; return new; ...
    Tom LaneTom Lane
    Jan 1, 2008 at 9:09 pm
    Jun 2, 2008 at 1:59 pm
  • Is it possible to authenticate using GSSAPI over the V2 protocol? Is there any documentation on the message formats for V2? Kris Jurka
    Kris JurkaKris Jurka
    Jan 29, 2008 at 8:34 am
    Feb 8, 2008 at 6:24 pm
  • Hello is any chance to share standard Makefile and RH Makefile? I am sorry. I don't understand to Makefile absolutely. It's look so global Makefile need some changes. Any help is welcome. Regards ...
    Pavel StehulePavel Stehule
    Jan 21, 2008 at 11:01 am
    Jan 22, 2008 at 12:34 pm
  • Hi, I'd like to implement some simple data logging via triggers on a small number of infrequently updated tables and I'm wondering if there are some helpful functions, plugins or idioms that would ...
    Ivan VorasIvan Voras
    Jan 26, 2008 at 5:35 pm
    Jan 27, 2008 at 5:39 pm
  • Hi, While translating the backend's message catalog I found several things that should probably be improved. For example, in regis.c there are several strings talking about "regis pattern". I had ...
    Alvaro HerreraAlvaro Herrera
    Jan 20, 2008 at 12:13 am
    Jan 21, 2008 at 2:59 am
  • Regarding to Robert Mach's work during Google SOC on data integrity check. I would like to improve storage module and implement some Robert's code into the core. I would like to make following ...
    Zdenek KotalaZdenek Kotala
    Jan 25, 2008 at 4:57 pm
    May 12, 2008 at 7:14 pm
  • select to_char(date, 'yyyy-mm-dd hh24:mi:ss.ms') as char, date from (select timestamp'2008-01-30 15:06:21.560' as date) sub "2008-01-30 15:06:21.560";"2008-01-30 15:06:21.56" Why does the timestamp ...
    Roberts, JonRoberts, Jon
    Jan 31, 2008 at 3:36 pm
    Feb 1, 2008 at 1:58 am
  • We previously tried to send this proposal/patch, but it never showed up. We tried twice in a 16 hour period. It might be something with the attachment, who knows. This time, we are providing a URL ...
    Andrew ChernowAndrew Chernow
    Jan 8, 2008 at 2:50 pm
    Jan 9, 2008 at 8:11 am
  • Hi everyone, I believe that there is a small bug in src/port/rint.c when the input parameter has a fractional part of 0.5 which is demonstrated by the attached program. It appears that the PG version ...
    Mark Cave-AylandMark Cave-Ayland
    Jan 20, 2008 at 9:14 pm
    Mar 25, 2008 at 12:56 pm
  • Hi, I'm following the 8.3 beta releases for some time now, mostly using the Win32 with Installer package. 8.3beta3 and 4 have worked perfectly with the provided pljava ddl, just with 8.3-rc1 it ...
    Jan IschebeckJan Ischebeck
    Jan 10, 2008 at 10:40 pm
    Jan 22, 2008 at 3:46 am
  • Hello I propose two kinds of functions: a) generic functions - this function allows any params without any implicit casting (it can implemented only in C language). This function have to have ...
    Pavel StehulePavel Stehule
    Jan 18, 2008 at 6:34 pm
    Jan 20, 2008 at 10:26 pm
  • http://www.scientificcomputing.com/ShowPR~PUBCODE~030~ACCT~3000000100~IS SUE~0801~RELTYPE~HPCC~PRODCODE~00000000~PRODLETT~C.html http://www.nvidia.com/object/cuda_learn.html ...
    Dann CorbitDann Corbit
    Jan 30, 2008 at 6:13 am
    Jan 31, 2008 at 1:36 pm
  • Hello all, I have a ~150GB sized server, containing two databases that are active in mostly read mode. I have noticed lately that the global/pgstat.stat file is somewhere around 1MB freshly after a ...
    Cristian GaftonCristian Gafton
    Jan 29, 2008 at 4:39 pm
    Jan 29, 2008 at 10:37 pm
  • I was just noticing that $SUBJECT is hard --- the entry in current_query looks exactly like a manual vacuum command, and there's not anything in the other fields that looks different either. Since ...
    Tom LaneTom Lane
    Jan 13, 2008 at 9:59 pm
    Jan 14, 2008 at 2:24 am
  • I recently noticed that SQL:200n[1] defines a new aggregate function, array_agg(). The relevant portions of the spec are: p. 66: "If ARRAY_AGG is specified, then an array value with one element ...
    Neil ConwayNeil Conway
    Jan 28, 2008 at 6:11 am
    Mar 25, 2008 at 2:58 am
  • I came across some rather strange choices of lock levels in pg_shdepend.c. Why does shdepDropOwned() take AccessExclusiveLock on pg_shdepend? Seems like RowExclusiveLock should be sufficient. If it ...
    Tom LaneTom Lane
    Jan 21, 2008 at 9:58 pm
    Jan 28, 2008 at 11:59 pm
  • Hi -hackers, While testing RC2 on the new servers of one of our customers, I found a query really slow on the new server which is quite fast on the old box currently in production (production is 8.1 ...
    Guillaume SmetGuillaume Smet
    Jan 22, 2008 at 6:52 pm
    Jan 23, 2008 at 2:34 pm
  • Who decided this part of pg_regress.c was a good idea? /* try to create the test tablespace dir if it doesn't exist */ snprintf(testtablespace, MAXPGPATH, "%s/testtablespace", abs_builddir); if ...
    Tom LaneTom Lane
    Jan 18, 2008 at 7:33 pm
    Jan 19, 2008 at 3:06 pm
  • There was some discussion today about restoring pg_dump output as a non-superuser: http://archives.postgresql.org/pgsql-admin/2008-01/msg00128.php In 8.3 we have eliminated one of the major ...
    Tom LaneTom Lane
    Jan 13, 2008 at 1:56 am
    Jan 13, 2008 at 6:09 pm
  • In my striving towards more effective partitioning for Postgres, I see we have one main decision to make and that all other sub-tasks are driven directly by this one issue. The issue is: At what ...
    Simon RiggsSimon Riggs
    Jan 11, 2008 at 10:25 am
    Jan 11, 2008 at 1:26 pm
  • I am using tsearch2 with pgsql 8.2.5 and get the following error when calling to_tsvector : "translation failed from server encoding to wchar_t" My database is UTF8 encoded and the data sent to ...
    IlancoIlanco
    Jan 7, 2008 at 7:22 pm
    Jan 8, 2008 at 12:53 pm
  • Greetings, Attached is a rather small change to src/bin/psql/describe.c to show database size and permissions when using the psql \l command. Typical output would be: List of databases Name | Owner | ...
    Andrew GilliganAndrew Gilligan
    Jan 20, 2008 at 1:12 am
    Mar 30, 2008 at 6:11 pm
  • In reading our array documentation I came across two unusual behaviors. The issue relates to slices: We can also access arbitrary rectangular slices of an array, or subarrays. An array slice is ...
    Bruce MomjianBruce Momjian
    Jan 15, 2008 at 4:31 am
    Mar 26, 2008 at 2:43 pm
  • Greetings, In doing some test on 8.3RC2, I was dismayed to discover that the pl/pgsql plan invalidation logic added doesn't consider changing the search_path to invalidate a plan. Our case is where ...
    Stephen FrostStephen Frost
    Jan 28, 2008 at 3:17 am
    Mar 26, 2008 at 2:40 am
  • Whilst trying to reproduce bug #3902 I noticed that the code doesn't work with an abbreviated host name: $ psql -l -h rh2.sss.pgh.pa.us List of databases ... everything's fine ... $ psql -l -h rh2 ...
    Tom LaneTom Lane
    Jan 28, 2008 at 12:02 am
    Jan 30, 2008 at 10:27 pm
  • I need to set a basic password policy for accounts but I don't see any documentation on how to do it. I'm assuming there is a way to do this, maybe even with a trigger. The policy would be something ...
    Roberts, JonRoberts, Jon
    Jan 15, 2008 at 10:11 pm
    Jan 22, 2008 at 5:01 pm
  • Hi Simon, and Dave,Magnus. About pg_standby, a link option cause a problem in windows(XP and 2k,2k3). It is because the call of mklink is needed. Then, they are the new programs of VISTA and 2008. It ...
    Hiroshi SaitoHiroshi Saito
    Jan 21, 2008 at 6:36 am
    Jan 21, 2008 at 1:17 pm
Jan 2008
123
Group Navigation
period‹ prev | Jan 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions134
posts1,219
users148
websitepostgresql.org...
irc#postgresql

148 users for January 2008

Tom Lane: 242 posts Simon Riggs: 86 posts Alvaro Herrera: 57 posts Andrew Dunstan: 41 posts Gregory Stark: 40 posts Markus Schiltknecht: 38 posts Bruce Momjian: 35 posts Magnus Hagander: 35 posts Joshua D. Drake: 32 posts Gokulakannan Somasundaram: 28 posts Kevin Grittner: 28 posts Pavel Stehule: 26 posts Guillaume Smet: 20 posts Gavin Sherry: 18 posts Roberts, Jon: 18 posts Martijn van Oosterhout: 15 posts Andrew Sullivan: 14 posts Peter Eisentraut: 14 posts Decibel!: 13 posts Josh Berkus: 12 posts
show more
Archives