FAQ

Search Discussions

132 discussions - 1,517 posts

  • In MySQL the below query is executing properly. SELECT * FROM <Table-name WHERE (Table.ID LIKE '1%') But when i try to execute the above query in Postgres, i get the following Exception ...
    PremanandPremanand
    Feb 17, 2012 at 5:33 am
    Dec 16, 2012 at 2:40 pm
  • Hi, Please find attached the latest version of the command triggers patch, in context diff format, with support for 79 commands and documentation about why only those, and with some limitations ...
    Dimitri FontaineDimitri Fontaine
    Feb 24, 2012 at 10:05 pm
    Mar 20, 2012 at 5:45 pm
  • Attached is a revision of the pg_stat_statements normalisation patch, plus its Python/psycopg2/dellstore2 test suite, which has yet to be converted to produce pg_regress output. This revision is a ...
    Peter GeogheganPeter Geoghegan
    Feb 16, 2012 at 9:12 pm
    Apr 9, 2012 at 3:19 pm
  • The documentation of the pg_upgrade -l/--logfile option never made much sense to me: -l, --logfile=FILENAME log session activity to file I don't know what "session" means for pg_upgrade, so I never ...
    Peter EisentrautPeter Eisentraut
    Feb 19, 2012 at 11:13 am
    Mar 12, 2012 at 11:49 pm
  • Hi! I've always been a little wary of using the TRUNCATE command due to the warning in the documentation about it not being "MVCC-safe": queries may silently give wrong results and it's hard to tell ...
    Marti RaudseppMarti Raudsepp
    Feb 9, 2012 at 9:12 pm
    Apr 21, 2012 at 8:08 pm
  • I missed all the fun while the "leakproof" addition to function attributes was being decided, so I know I'm late to the party. Today I had to go and look up what it actually meant. I have to say that ...
    Andrew DunstanAndrew Dunstan
    Feb 19, 2012 at 10:29 pm
    Feb 27, 2012 at 10:49 pm
  • As those who've been paying attention to it know, our regular expression library is based on code originally developed by Henry Spencer and contributed by him to the Tcl project. We adopted it out of ...
    Tom LaneTom Lane
    Feb 18, 2012 at 6:15 pm
    Mar 10, 2012 at 4:27 pm
  • Hi! Oleg and me found an incorrect behaviour when using a GiST index on points. It's quite easy to reproduce. test=# create table test as values (0,0.0000001); test=# insert into test values ...
    Alexander KorotkovAlexander Korotkov
    Feb 16, 2012 at 7:43 am
    Nov 10, 2012 at 3:55 pm
  • Hi, When I compiled HEAD with --disable-integer-datetimes and tested pg_receivexlog, I encountered unexpected replication timeout. As far as I read the pg_receivexlog code, the cause of this problem ...
    Fujii MasaoFujii Masao
    Feb 7, 2012 at 5:58 am
    Jun 10, 2012 at 10:23 am
  • Last year at this time, I was investigating things like ext3 vs xfs, how well Linux's dirty_bytes parameter worked, and how effective a couple of patches were on throughput & latency. The only patch ...
    Greg SmithGreg Smith
    Feb 14, 2012 at 6:46 pm
    Apr 11, 2012 at 1:30 am
  • Hi, This may have already been discussed before, but I can't find any mention of it. Would it be desirable to add support for triggers that contain their own anonymous functions (i.e. DO)? So instead ...
    Thom BrownThom Brown
    Feb 17, 2012 at 1:22 pm
    Mar 6, 2012 at 9:29 pm
  • Hi, we have a database that is storing strings in various encodings (and non-encodings, namely the arbitrary byte soup that you might see in email headers from the internet). For this reason, the ...
    Christoph BergChristoph Berg
    Feb 9, 2012 at 10:21 am
    Jul 17, 2012 at 6:12 pm
  • I'm trying to understand what options I have to test "CREATE EXTENSION" w/out installing the extension files in their final destination. Could not find a way to set SHAREDIR from within psql, nor a ...
    Sandro SantilliSandro Santilli
    Feb 21, 2012 at 10:20 am
    Mar 2, 2012 at 10:08 pm
  • I was experimenting today with a test case sent to me by somebody at Red Hat. The details aren't too important, except that it involves an inner join on the inside of a left join (where it cannot ...
    Tom LaneTom Lane
    Feb 28, 2012 at 10:35 pm
    Apr 19, 2012 at 1:13 am
  • In bug #6457 it's pointed out that we *still* don't have full functionality for locale-dependent regexp behavior with UTF8 encoding. The reason is that there's old crufty code in regc_locale.c that ...
    Tom LaneTom Lane
    Feb 15, 2012 at 11:06 pm
    Feb 24, 2012 at 12:10 am
  • [Posted at Andres's request] TL;DR: Inserting and indexing cubes is slow and/or broken in various ways in various builds. NOTABLE PROBLEMS 1. In 9.1.2, inserting 10x rows takes 19x the time. - ...
    Jay LevittJay Levitt
    Feb 7, 2012 at 7:26 pm
    Mar 2, 2012 at 11:25 am
  • A long time ago, in a galaxy far away, we discussed ways to speed up data loads/COPY. http://archives.postgresql.org/pgsql-hackers/2007-01/msg00470.php In particular, the idea that we could mark ...
    Simon RiggsSimon Riggs
    Feb 24, 2012 at 8:55 pm
    Mar 3, 2012 at 8:48 pm
  • Hello I had to reply to query about usage VACUUM ANALYZE or ANALYZE. I expected so ANALYZE should be faster then VACUUM ANALYZE. But is not true. Why? Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Feb 21, 2012 at 2:00 pm
    Feb 25, 2012 at 8:14 pm
  • Just for kicks, I ran two 30-minute pgbench tests at scale factor 300 tonight on Nate Boley's machine, with -n -l -c 32 -j 32. The configurations were identical, except that on one of them, I set ...
    Robert HaasRobert Haas
    Feb 19, 2012 at 5:24 am
    Aug 31, 2012 at 5:14 am
  • Dear hackers, Thanks for the work on PLPython result metadata, it is very useful! I just came across a crash when trying to access this metadata on the result of an UPDATE, which obviously cannot ...
    Jean-Baptiste QuenotJean-Baptiste Quenot
    Feb 10, 2012 at 4:45 pm
    Apr 15, 2012 at 5:27 pm
  • In his blog entry http://www.depesz.com/2011/07/08/wish-list-for-psql/ depesz described a simple way to do tab completion for SELECT in psql: """ Make tab-completion complete also function names – ...
    Peter EisentrautPeter Eisentraut
    Feb 9, 2012 at 8:49 pm
    Feb 13, 2012 at 9:26 pm
  • Dave Malcolm at Red Hat has been working on a static code analysis tool for Python-related C code. He reports here on some preliminary results for plpython.c: ...
    Tom LaneTom Lane
    Feb 18, 2012 at 7:31 pm
    Mar 29, 2012 at 5:30 pm
  • I decided to take a crack at the todo item created from the following post: http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php The attached patch makes the desired changes in both ...
    Vik ReykjaVik Reykja
    Feb 12, 2012 at 2:07 am
    Aug 27, 2012 at 11:57 pm
  • [Preamble: I've been told that the hackers list is appropriate for extension-related topics like this, even if it's not about contributing to core. If I'm misappropriating, please let me know.] Goal: ...
    Jay LevittJay Levitt
    Feb 15, 2012 at 8:35 pm
    Feb 17, 2012 at 8:47 pm
  • Hello I found so this extremely simple patch should be useful. It helps for pattern SELECT fx(); There was thread about it. Regards Pavel
    Pavel StehulePavel Stehule
    Feb 19, 2012 at 7:11 pm
    Jun 19, 2012 at 4:17 am
  • Hello, This is my first patch review ever, so please bear with me. The patch[1] is in the context diff format and applies cleanly to current git HEAD. Documentation is updated by the patch. The code ...
    Alex ShulginAlex Shulgin
    Feb 1, 2012 at 12:54 pm
    Apr 5, 2012 at 6:20 pm
  • For (unit) testing, I have often had the need to override the current timestamp in the database system. For example, a column default, function, or views would make use of the current timestamp in ...
    Peter EisentrautPeter Eisentraut
    Feb 23, 2012 at 11:09 am
    Feb 27, 2012 at 7:44 pm
  • I have heard complaints that /contrib/pg_test_fsync is too slow. I thought it was impossible to speed up pg_test_fsync without reducing its accuracy. However, now that I some consumer-grade SATA 2 ...
    Bruce MomjianBruce Momjian
    Feb 14, 2012 at 12:43 am
    Feb 15, 2012 at 4:20 pm
  • On a development system which wasn't being monitored very closely I think we've uncovered a bug in the listen/notify behavior. The system was struggling with lack of disk space for about a week ...
    Kevin GrittnerKevin Grittner
    Feb 9, 2012 at 4:18 pm
    Jul 25, 2012 at 2:05 pm
  • Hi all, If someone wants to drop objects owned by a particular role, they'll use DROP OWNED BY role. However, the implications of this statement aren't easily known, and once you've run it, it's not ...
    Thom BrownThom Brown
    Feb 29, 2012 at 4:47 pm
    Mar 13, 2012 at 7:24 pm
  • The auto_explain module appears to create invalid JSON (in all versions since 9.0). For example, with the settings auto_explain.log_format = 'json' auto_explain.log_min_duration = 0 the query select ...
    Peter EisentrautPeter Eisentraut
    Feb 10, 2012 at 6:14 pm
    Feb 13, 2012 at 7:12 pm
  • Recent events have made me notice the OID handling. AFAICS, OIDs are just a sequence with a max value that fits in a uint. So ISTM that we should just strip out the OID handling code and just have a ...
    Simon RiggsSimon Riggs
    Feb 7, 2012 at 1:46 pm
    Feb 13, 2012 at 3:46 pm
  • Hi list, Andrew Dunstan reported an awkward-seeming case on IRC where shifting around a concatenation expression in a view made the planner choose a good or a bad execution plan. Simplified, it boils ...
    Marti RaudseppMarti Raudsepp
    Feb 7, 2012 at 8:18 pm
    Feb 8, 2012 at 5:54 pm
  • I'm working on implementing query cache in pgpool-II. I want to know if a table has been modified because pgpool-II has to invalidate cache if corresponding table is modified. For DDL/DML it would be ...
    Tatsuo IshiiTatsuo Ishii
    Feb 26, 2012 at 5:11 am
    Mar 6, 2012 at 9:26 pm
  • As per http://archives.postgresql.org/pgsql-general/2012-02/msg00304.php there is no switch case in shdepReassignOwned for foreign data wrappers. The obvious short-term answer (and probably the only ...
    Tom LaneTom Lane
    Feb 15, 2012 at 5:58 pm
    Feb 23, 2012 at 8:35 am
  • Hi All, This is regarding the TODO item : "Add SPI_gettypmod() to return a field's typemod from a TupleDesc" The related message is: http://archives.postgresql.org/pgsql-hackers/2005-11/msg00250.php ...
    Chetan SuttrawayChetan Suttraway
    Feb 1, 2012 at 10:24 am
    Feb 8, 2012 at 6:59 am
  • Pursuant to the recent discussion about bugs 6200 and 6245, I went trawling through all the WAL redo routines looking for bugs such as inadequate locking or transiently trashing shared buffers. ...
    Tom LaneTom Lane
    Feb 5, 2012 at 7:19 pm
    Feb 6, 2012 at 7:44 pm
  • According to me update logs, somewhere between zlib versions 1.2.3.4 and 1.2.6, the definition of the gzFile type was changed from void * to struct gzFile_s *, an opaque struct. Note that gzFile is ...
    Peter EisentrautPeter Eisentraut
    Feb 23, 2012 at 9:16 am
    Mar 19, 2012 at 7:07 pm
  • Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? ie where the admin can assign drives with good random read behaviour (but perhaps also-ran random ...
    JamesJames
    Feb 22, 2012 at 10:31 pm
    Feb 29, 2012 at 3:57 pm
  • Looking over the SSI 2PC code recently, I noticed that I overlooked a case that could lead to non-serializable behavior after a crash. When we PREPARE a serializable transaction, we store part of the ...
    Dan PortsDan Ports
    Feb 14, 2012 at 2:57 am
    Feb 29, 2012 at 2:59 pm
  • Hackers, Is there a reason that hashtext() and friends are not documented? Given that they’re likely to be used more and more for partitioning and sharding, I think it would be useful to do so, ...
    David E. WheelerDavid E. Wheeler
    Feb 21, 2012 at 7:50 pm
    Feb 21, 2012 at 8:51 pm
  • I've asked for this a few times before, but it seems others aren't as keen on it as me :-) Personally, I find the docs easier to read when formatted with the new website styles that Thom put ...
    Magnus HaganderMagnus Hagander
    Feb 25, 2012 at 12:54 pm
    Mar 13, 2012 at 5:26 pm
  • Say I'm writing an extension X, and I want to process data values from another extension that creates type Y (e.g. an hstore), what's the best way to determine the Oid of type Y in my module X code? ...
    Andrew DunstanAndrew Dunstan
    Feb 22, 2012 at 6:01 pm
    Feb 22, 2012 at 9:46 pm
  • I looked into the complaint here of poor estimation for GIN indexscans: http://archives.postgresql.org/pgsql-performance/2012-02/msg00028.php At first glance it sounds like a mistake in selectivity ...
    Tom LaneTom Lane
    Feb 16, 2012 at 11:15 pm
    Feb 20, 2012 at 2:32 pm
  • This patch makes me a little nervous, because the existing behavior seems to have been coded for quite deliberately. Sadly, I don't see any comments explaining why the RESET case was excluded ...
    Robert HaasRobert Haas
    Feb 15, 2012 at 6:24 pm
    Feb 16, 2012 at 9:54 pm
  • I noticed ecpglib still uses PQconnectdb() with a craftily assembled connection string. Here is a patch to use PQconnectdbParams() instead.
    Peter EisentrautPeter Eisentraut
    Feb 2, 2012 at 6:03 pm
    Feb 13, 2012 at 11:21 am
  • Hi, http://www.depesz.com/2012/02/03/waiting-for-9-2-pg_basebackup-from-slave/ The above article points out the problem of pg_basebackup from the standby: when "-x stream" is specified, pg_basebackup ...
    Fujii MasaoFujii Masao
    Feb 7, 2012 at 11:31 am
    May 25, 2012 at 9:32 am
  • Attached is a feature extracted from the Ants Aasma "add timing of buffer I/O requests" submission. That included a tool to measure timing overhead, from gettimeofday or whatever else ...
    Greg SmithGreg Smith
    Feb 22, 2012 at 11:54 am
    Mar 27, 2012 at 8:25 pm
  • Hi there, attached patch introduces NULLs indexing for SP-GiST. With this patch Sp-GiST supports IS NULL, IS NOT NULL clauses, as well as full index scan. We added boolean satisfyAll field in ...
    Oleg BartunovOleg Bartunov
    Feb 2, 2012 at 9:26 pm
    Mar 11, 2012 at 4:01 pm
  • When running Postgres on a single ext3 filesystem on Linux, we find that the attached simple patch gives significant performance benefit (7-8% in numbers below). The patch adds a new option for ...
    Dan ScalesDan Scales
    Feb 16, 2012 at 5:18 pm
    Mar 2, 2012 at 10:28 pm
Group Navigation
period‹ prev | Feb 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions132
posts1,517
users144
websitepostgresql.org...
irc#postgresql

144 users for February 2012

Robert Haas: 193 posts Tom Lane: 192 posts Simon Riggs: 78 posts Peter Eisentraut: 53 posts Andrew Dunstan: 50 posts Bruce Momjian: 50 posts Alvaro Herrera: 48 posts Dimitri Fontaine: 39 posts Fujii Masao: 36 posts Kevin Grittner: 35 posts Thom Brown: 33 posts Greg Smith: 31 posts Heikki Linnakangas: 31 posts Magnus Hagander: 30 posts Pavel Stehule: 30 posts Peter Geoghegan: 29 posts Marko Kreen: 28 posts Jeff Janes: 25 posts Shigeru Hanada: 24 posts Noah Misch: 22 posts
show more
Archives