Search Discussions

92 discussions - 989 posts

  • A few months ago a security concern was sent to core. We have discussed it but see little we can do to address it in the code so I am posting to hackers in case there is something we didn't think of ...
    Bruce MomjianBruce Momjian
    Dec 22, 2007 at 2:25 pm
    Jan 28, 2008 at 7:53 pm
  • I'm starting work on next projects for 8.4. Many applications have the need to store very large data volumes for both archival and analysis. The analytic databases are commonly known as Data ...
    Simon RiggsSimon Riggs
    Dec 11, 2007 at 11:11 am
    Dec 20, 2007 at 8:04 pm
  • I'm fairly surprised these queries work. Is there some reason why we support this? April Fools Day? Jules Verne? I'm all for fast queries, but zero seems like the lowest value we should support... ...
    Simon RiggsSimon Riggs
    Dec 14, 2007 at 1:18 am
    Mar 10, 2008 at 3:40 am
  • Many applications have the need to archive data after it has been through the initial flurry of reads and updates that follows its original insertion. Currently there is no specific feature support ...
    Simon RiggsSimon Riggs
    Dec 11, 2007 at 11:12 am
    Dec 19, 2007 at 11:35 am
  • Agree with Greg's analysis here. Moving to -hackers now. I've done performance profiling also. My results replicated Tom's, but I hadn't performed them on a big enough system and so didn't realise ...
    Simon RiggsSimon Riggs
    Dec 13, 2007 at 8:27 am
    Dec 14, 2007 at 3:37 pm
  • Hi, I am encountering problems when trying to run VACUUM FULL ANALYZE on a particular table in my database; namely that the process crashes out with the following problem: INFO: vacuuming ...
    Michael AkindeMichael Akinde
    Dec 11, 2007 at 10:00 am
    Jan 16, 2008 at 10:35 pm
  • Greetings, Discussing psql options made me recall an annoying problem that we've run into. There's no way (unless it was added to 8.3 and I missed it, but I don't think so) to tell pg_dump 'switch to ...
    Stephen FrostStephen Frost
    Dec 10, 2007 at 4:02 pm
    Jan 5, 2009 at 4:56 pm
  • Hi! When you redid the msvc build stuff you seem to have missed the documentatino.. Specifically, I notice that buildenv.pl isn't documented - docs still say buildenv.bat is the way to go. Also, do ...
    Magnus HaganderMagnus Hagander
    Dec 3, 2007 at 10:11 am
    Dec 19, 2007 at 12:30 pm
  • The point here is that CSV-format log output doesn't include the DETAIL, HINT, or context (QUERY/STATEMENT/CONTEXT) lines that you might get with normal output. I suppose this was intentional in ...
    Tom LaneTom Lane
    Dec 6, 2007 at 5:11 pm
    Dec 11, 2007 at 3:45 pm
  • Hi, Currently we check for the existence of NULL values in the tuple and we set the has_null flag. If the has_null flag is present, the tuple will be storing a null bitmap. What i propose is a) By ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Dec 17, 2007 at 7:40 am
    Mar 25, 2008 at 7:36 pm
  • rob@ridley:~$ ~rob/devel/postgresql/83/bin/psql -h localhost -u rob -p 5483] psql: Warning: The -u option is deprecated. Use -U. User name: rob Password for user : Welcome to psql 8.3beta2, the ...
    Robert TreatRobert Treat
    Dec 9, 2007 at 4:49 pm
    Dec 12, 2007 at 12:10 am
  • Am I the only one who finds the phrase "distributed checkpointing" a bit awkward? Would it be better if we used "time-distributed checkpointing" instead? The phrase is used in the release notes, but ...
    Alvaro HerreraAlvaro Herrera
    Dec 6, 2007 at 10:03 pm
    Dec 13, 2007 at 5:48 pm
  • We currently execute a lot of joins as Nested Loops which would be more efficient if we could batch together all the outer keys and execute a single inner bitmap index scan for all of them together. ...
    Gregory StarkGregory Stark
    Dec 13, 2007 at 1:16 pm
    Apr 7, 2008 at 9:31 am
  • Hello all, i'm in the need to create a boolean datatype which returns an integer instead of the usual 't'/'f'. Before anyone starts to point me at casts: it's a lot overhead to cast some hundred ...
    Andreas 'ads' ScherbaumAndreas 'ads' Scherbaum
    Dec 25, 2007 at 10:33 am
    Dec 28, 2007 at 3:58 am
  • Agreed, this would be a nice 8.4 thing. But what about 8.3 and 8.2? Is there a reason not to make this change? I know I've been lazy and not run any absolute figures, but rough tests show that ...
    Greg Sabino MullaneGreg Sabino Mullane
    Dec 5, 2007 at 2:25 pm
    Feb 4, 2008 at 4:01 am
  • Maybe a key management solution isn't required. If, instead of strictly wrapping a language with an encryption layer, we provide hooks (actors) that have the ability to operate on the function body ...
    Merlin MoncureMerlin Moncure
    Dec 21, 2007 at 5:59 am
    Dec 22, 2007 at 12:28 am
  • Recently there was a post on -performance about a particular case where Postgres doesn't make very good use of the I/O system. This is when you try to fetch many records spread throughout a table in ...
    Gregory StarkGregory Stark
    Dec 2, 2007 at 1:17 pm
    Jan 28, 2008 at 7:53 pm
  • The problem complained of in bug #3843 was something I'd noticed a few days ago and meant to fix. ISTM the recent change to have the archiver outlive the postmaster was incompletely thought out, and ...
    Tom LaneTom Lane
    Dec 27, 2007 at 8:29 pm
    Jan 9, 2008 at 3:31 pm
  • Failures of archive_command calls report a confusing exit status such as: LOG: archive command "cp 'pg_xlog/000000010000000000000000' '/nonexistent/000000010000000000000000'" failed: return code 256 ...
    Peter EisentrautPeter Eisentraut
    Dec 10, 2007 at 5:27 pm
    Dec 12, 2007 at 1:00 am
  • I've wanted for a long time to have EXPLAIN ANALYZE output per-node I/O usage. This would be especially useful if we could distinguish hardware versus logical I/O though. And I always thought that ...
    Gregory StarkGregory Stark
    Dec 14, 2007 at 3:47 pm
    Jan 3, 2008 at 4:11 pm
  • Hi, It seems pgindent is not considering EXEC_BACKEND typedefs. For example, static void restore_backend_variables(BackendParameters * param, Port *port); BackendParameters is not considered a ...
    Alvaro HerreraAlvaro Herrera
    Dec 7, 2007 at 12:46 am
    Mar 18, 2008 at 11:22 pm
  • As of CVS HEAD, some of the contrib module documentation pages have extensive credit screeds, eg http://developer.postgresql.org/pgdocs/postgres/cube.html and some just have the author's name, with ...
    Tom LaneTom Lane
    Dec 6, 2007 at 4:58 am
    Dec 9, 2007 at 5:04 pm
  • Hi, I tried to run make postgres.pdf (PostgreSQL 8.3beta4), and got this error: cp ./../graphics/postgres.gif . cp: cannot stat `./../graphics/postgres.gif': No such file or directory make: *** ...
    Devrim GÃNDÃZDevrim GÃNDÃZ
    Dec 3, 2007 at 8:28 pm
    Dec 5, 2007 at 11:08 am
  • Hi. I think this has many problems. However, by the reason the release is approaching, this is not the situation which I'm looking at leisurely...... Server message has a problem by 8.3beta4 on ...
    Hiroshi SaitoHiroshi Saito
    Dec 10, 2007 at 3:18 pm
    Dec 12, 2007 at 3:02 am
  • Both array and record binary recv functions require that the recv'd Oid match the Oid of what the backend has deduced. We don't think this behavior gets you very much. The backend apparently knows ...
    Andrew ChernowAndrew Chernow
    Dec 18, 2007 at 3:19 pm
    Jan 27, 2009 at 3:31 pm
  • Folks, I've just noticed that pg_controldata doesn't say anything about whether the database is 64-bit or 32-bit. Since the data files can be incompatible based on word length, shouldn't that be in ...
    Josh BerkusJosh Berkus
    Dec 8, 2007 at 2:53 am
    Dec 8, 2007 at 12:01 pm
  • Hi everyone, I think that I may have found a minor bug with PostgreSQL 8.3beta4 with respect to md5 authentication. I actually discovered this on Win32, but it appears that the behaviour is the same ...
    Mark Cave-AylandMark Cave-Ayland
    Dec 7, 2007 at 3:27 pm
    Dec 9, 2007 at 3:00 pm
  • Gregory StarkGregory Stark
    Dec 19, 2007 at 11:25 am
    Dec 19, 2007 at 4:45 pm
  • In trying to run a benchmark comparing mingw with VC++ builds Dave discovered that if you initdb with one and try to run with the other you get a message saying "incorrect checksum in control file" ...
    Gregory StarkGregory Stark
    Dec 6, 2007 at 2:19 pm
    Dec 7, 2007 at 12:19 pm
  • Hi there, just interested do we have a place where developers could post their availability for contract work ? For example, I and Teodor will be available soon for contract work and we prefer to ...
    Oleg BartunovOleg Bartunov
    Dec 17, 2007 at 4:28 pm
    Dec 18, 2007 at 6:40 pm
  • We will have a 0.6 patch tomorrow. This is not a patch, its a proposal. The implementation has been adjusted and is now a simple printf-style interface. This is just a design proposal to see if ...
    Andrew ChernowAndrew Chernow
    Dec 10, 2007 at 11:22 pm
    Dec 12, 2007 at 8:19 pm
  • There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge added to work around a Windows problem which makes it work but at great expense: #ifdef WIN32 /* * Windows reports that ...
    Gregory StarkGregory Stark
    Dec 3, 2007 at 5:41 pm
    Jun 23, 2008 at 9:47 pm
  • I found a tiny fix for configure.in at Nov 26. http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.in.diff?r1=1.537;r2=1.538;f=h It seems to me this check enforces us to use autoconf 2.59, not ...
    KaiGai KoheiKaiGai Kohei
    Dec 19, 2007 at 1:07 am
    Dec 19, 2007 at 5:19 am
  • Now that we have set archiver messages to DEBUG levels, there's no easy way of seeing what file we are currently working on. The behaviour of the startup process and archiver should be symmetrical, ...
    Simon RiggsSimon Riggs
    Dec 13, 2007 at 10:45 am
    Dec 13, 2007 at 3:12 pm
  • Hi all, I'm not sure psql handles \dFp the right way. The query allows translators to translate some columns' values but forgets to escape the strings. So, here is a patch that escapes these ...
    Guillaume LelargeGuillaume Lelarge
    Dec 11, 2007 at 6:17 pm
    Dec 11, 2007 at 10:42 pm
  • Is the project file really the proper place? Consider an add-on module - wouldn't we want the setting to go in that one as well? meaning we'd have it in a header file instead? /Magnus
    Magnus HaganderMagnus Hagander
    Dec 7, 2007 at 12:49 pm
    Dec 11, 2007 at 2:35 pm
  • Is there a reason why pg_dump avoids using BINARY mode COPY? (Or am I missing something?) Unless there is a specific reason not to we could/should allow an option on the dump. -- Simon Riggs ...
    Simon RiggsSimon Riggs
    Dec 6, 2007 at 5:29 pm
    Dec 7, 2007 at 12:51 pm
  • A simple query: select prec.bl_considerada_prioritaria AS "A proposta é considerada prioritária por Conselho Municipal ou Estadual" from consultaprevia2008.tab_urb_asse_prec prec The result: ERROR: ...
    Walter CruzWalter Cruz
    Dec 4, 2007 at 5:18 pm
    Dec 6, 2007 at 6:16 am
  • I'm thinking that there isn't any way currently of working out how big a compressed toast object is? All existing functions decompress the object before we do anything to it, AFAICS. Am I missing ...
    Simon RiggsSimon Riggs
    Dec 4, 2007 at 4:31 pm
    Dec 5, 2007 at 9:40 am
  • Hello I have a stored procedure which does the billing stuff in our system,it works ok,but if I put in production,where there is some 5-10 billing events per second,the whole database slows down. It ...
    Dragan ZubacDragan Zubac
    Dec 2, 2007 at 2:40 am
    Dec 3, 2007 at 1:25 pm
  • Hi, Here's another problem report on Windows. This time it is usage of SSL connections and NOTIFY. I talked to Magnus on IRC and he directed me to bug #2829: ...
    Alvaro HerreraAlvaro Herrera
    Dec 12, 2007 at 2:40 am
    Mar 21, 2008 at 7:34 pm
  • Uh, I remember we looked at this checkbox before but I don't remember the details, and I can't find a comment about it. Was the issue that writethrough always forces through the disk cache? Is that ...
    Bruce MomjianBruce Momjian
    Dec 11, 2007 at 1:18 pm
    Dec 16, 2007 at 2:04 pm
  • Did we ever come to a conclusion on what to do with integer datetimes on msvc for 8.3? For the uninformed - 8.2 and earlier had the binary build with floating point timestamps, 8.3 has integer ...
    Magnus HaganderMagnus Hagander
    Dec 3, 2007 at 3:53 pm
    Dec 3, 2007 at 5:15 pm
  • Is there a reason why COPY TO STDOUT does not allow columns to be specified more than once? pei=# copy test1 (a, a) to stdout; ERROR: 42701: column "a" specified more than once Or is this just an ...
    Peter EisentrautPeter Eisentraut
    Dec 20, 2007 at 1:30 pm
    Dec 27, 2007 at 1:19 pm
  • I agree that the parenthised phrase should be removed. http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml?r1=1.387&r2=1.391 I think your proposed wording is removed enough ...
    Alvaro HerreraAlvaro Herrera
    Dec 18, 2007 at 12:32 pm
    Dec 22, 2007 at 5:32 am
  • hi, i would request you to answer the following query: 1. What is the maximum size of data single Bytea entry in column? i would be thankful to you for the above request . P.S : my current reqirement ...
    Arunachalam ParthasarathyArunachalam Parthasarathy
    Dec 20, 2007 at 5:35 pm
    Dec 20, 2007 at 5:54 pm
  • Hi, Does anybody have an information about GiST index benchmark? I'm planning to run GiST benchmark and analyze WAL structure to see PG's dynamic behavior. Regards; ------ Koichi Suzuki
    Koichi SuzukiKoichi Suzuki
    Dec 19, 2007 at 7:25 am
    Dec 20, 2007 at 3:08 pm
  • Hi all, I wonder why my ecxt_scantuple has a TupleDesc matching the subplan's tlist, not my plan's tlist. Basically, my question is what is x in econtext- ecxt_scantuple = x ? I have written a new ...
    Peter TrautmeierPeter Trautmeier
    Dec 17, 2007 at 11:45 am
    Dec 18, 2007 at 5:14 pm
  • Hi All, I am new to this mailing list and want to participate to the 8.3.0 beta program. (Sorry to be late BTW) My name is Sebastien FLAESCH and I am in charge of the database interfaces at Four J's ...
    Sebastien FLAESCHSebastien FLAESCH
    Dec 18, 2007 at 2:36 pm
    Dec 18, 2007 at 3:49 pm
  • If I create a binary cursor on a recent version of PostgreSQL, how can I tell if the timestamp data internally is an 8 byte double or an 8 byte integer? I see an #ifdef that changes the code path to ...
    Dann CorbitDann Corbit
    Dec 11, 2007 at 9:08 pm
    Dec 11, 2007 at 9:29 pm
Group Navigation
period‹ prev | Dec 2007 | next ›
Group Overview
grouppgsql-hackers @

114 users for December 2007

Tom Lane: 145 posts Bruce Momjian: 73 posts Gregory Stark: 65 posts Andrew Dunstan: 60 posts Magnus Hagander: 58 posts Simon Riggs: 58 posts Alvaro Herrera: 45 posts Joshua D. Drake: 39 posts Peter Eisentraut: 22 posts Andrew Sullivan: 21 posts Mark Mielke: 19 posts Andrew Chernow: 17 posts Greg Smith: 15 posts Josh Berkus: 15 posts Gokulakannan Somasundaram: 14 posts Dave Page: 12 posts Martijn van Oosterhout: 12 posts Alvaro Herrera: 11 posts Trevor Talbot: 10 posts Dann Corbit: 9 posts
show more