FAQ

PostgreSQL > pgsql-hackers > August 2013

Search Discussions

125 discussions - 1,430 posts

  • Hackers, This seems reasonable: david=# DO $$ david$# BEGIN david$# WITH now AS (SELECT now()) david$# SELECT * from now; david$# END; david$# $$; ERROR: query has no destination for result data ...
    David E. WheelerDavid E. Wheeler
    Aug 20, 2013 at 12:04 pm
    Aug 29, 2013 at 11:28 pm
  • Hi all, I recently tried a simple benchmark to see how far 9.4 had come since 8.4, but I discovered that I couldn't get 9.4 to even touch 8.4 for performance. After checking 9.2 and 9.3 (as per Kevin ...
    Thom BrownThom Brown
    Aug 7, 2013 at 4:21 pm
    Aug 21, 2013 at 1:44 am
  • After someone in IRC asked if there was an equivalent to MySQL's server_id, it was noted that we do have a system identifier but it's not very accessible. The attached patch implements a ...
    Vik FearingVik Fearing
    Aug 21, 2013 at 9:43 pm
    Aug 29, 2013 at 3:07 pm
  • Hi all, We discussed the $SUBJECT in the following threads: http://www.postgresql.org/message-id/CA+TgmoZbR+WL8E7MF_KRp6fY4FD2pMr11TPiuyjMFX_Vtg1Wrw@mail.gmail.com ...
    Fujii MasaoFujii Masao
    Aug 5, 2013 at 6:25 pm
    Aug 19, 2013 at 6:09 pm
  • My $company recently acquired another postgres based $company and migrated all their server operations into our datacenter. Upon completing the move, the newly migrated database server started ...
    Merlin MoncureMerlin Moncure
    Aug 5, 2013 at 3:49 pm
    Aug 22, 2013 at 1:07 pm
  • So I was hacking away at supporting variadic aggregates (per an internal request at Salesforce), and had it pretty much working, when I came across this old comment in opr_sanity.sql: -- Check that ...
    Tom LaneTom Lane
    Aug 29, 2013 at 7:55 pm
    Aug 31, 2013 at 3:02 am
  • Andrew GierthAndrew Gierth
    Aug 13, 2013 at 1:55 pm
    Aug 28, 2013 at 4:11 am
  • Hi, By default, PL/pgSQL does not print the error context of a RAISE statement, for example: =# create function foof() returns void as $$ begin raise exception 'foo'; end $$ language plpgsql; CREATE ...
    Marko TiikkajaMarko Tiikkaja
    Aug 21, 2013 at 12:28 pm
    Aug 23, 2013 at 8:36 am
  • Michael CronenworthMichael Cronenworth
    Aug 16, 2013 at 11:57 pm
    Aug 22, 2013 at 6:02 am
  • Someone on IRC a while ago was complaining that there was no way to specify an interval for pg_sleep, so I made one. Patch against today's HEAD attached. Usage: SELECT pg_sleep(interval '2 ...
    Vik FearingVik Fearing
    Aug 8, 2013 at 11:52 am
    Aug 23, 2013 at 7:55 pm
  • Hi, Could anyone tell me how to create read-only view on PostgreSQL 9.3 ? I've been testing updatable views and noticed that all simple views are updatable. When I use pg_dump for upgrading from ...
    Tomonari KatsumataTomonari Katsumata
    Aug 13, 2013 at 9:43 am
    Aug 14, 2013 at 3:14 am
  • Hi, Attached patch adds new GUC parameter 'compress_backup_block'. When this parameter is enabled, the server just compresses FPW (full-page-writes) in WAL by using pglz_compress() before inserting ...
    Fujii MasaoFujii Masao
    Aug 30, 2013 at 2:56 am
    Aug 30, 2013 at 10:34 pm
  • Hello, We are suffering from a long-standing issue with autovacuuming/vacuuming system catalogs on the production server. We are actively using temporary tables in the legacy application, so system ...
    Vlad ArkhipovVlad Arkhipov
    Aug 6, 2013 at 5:56 am
    Aug 22, 2013 at 11:15 pm
  • Greetings all: I spoke to Josh B and company at OSCON about a feature we really need for PostgreSQL extensions on OpenShift (Red Hat's Platform as a Service). What we need is the ability for ...
    Steven Citron-PoustySteven Citron-Pousty
    Aug 17, 2013 at 9:53 pm
    Aug 19, 2013 at 11:42 pm
  • I noticed pg_dump does not exit gracefully when killed. start pg_dump kill pg_dump by ctrl-c ps x 27246 ? Ds 96:02 postgres: t-ishii dbt3 [local] COPY 29920 ? S 0:00 sshd: ishii@pts/5 29921 pts/5 Ss ...
    Tatsuo IshiiTatsuo Ishii
    Aug 10, 2013 at 2:39 am
    Aug 12, 2013 at 11:02 pm
  • Hello pgsql-hackers , With reference to "Add XML Schema validation and xmlvalidate functions (SQL:2008)" in ToDo list, we have gone through pgsql-mailing list but we didn't find any significant work ...
    Kodamasimham Pridhvi (MT2012066)Kodamasimham Pridhvi (MT2012066)
    Aug 8, 2013 at 4:42 am
    Aug 12, 2013 at 4:25 pm
  • pg_dump goes to great lengths not to hard-code the schema name into commands like CREATE TABLE, instead setting the search_path before creating the table; these commands: CREATE SCHEMA xx; CREATE ...
    Bruce MomjianBruce Momjian
    Aug 9, 2013 at 4:04 am
    Aug 13, 2013 at 3:46 pm
  • The attached patch is motivated by http://www.postgresql.org/message-id/CAJYQwwRYt9RMBzs-sH6uCr1OTG4joXqkDF-fkoYP6pv12t0dsQ@mail.gmail.com in which it appears that Oliver Elphick forgot to look in ...
    Tom LaneTom Lane
    Aug 9, 2013 at 2:32 am
    Aug 10, 2013 at 4:35 pm
  • Hi, Please find attached to this email the latest and greatest version of in-line SQL only extensions support, known as "Extension Templates" and which could be renamed "In-Catalog Extension ...
    Dimitri FontaineDimitri Fontaine
    Aug 1, 2013 at 5:01 pm
    Aug 29, 2013 at 10:16 am
  • Hello, A few days before, I got a question as described in the subject line on a discussion with my colleague. In general, larger i/o size per system call gives us wider bandwidth on sequential read, ...
    Kohei KaiGaiKohei KaiGai
    Aug 22, 2013 at 7:53 pm
    Aug 27, 2013 at 9:04 pm
  • I've been looking at what it would take to do proper cost estimation for the recently-discussed patch to suppress calculation of unnecessary ORDER BY expressions. It turns out that knowledge of that ...
    Tom LaneTom Lane
    Aug 4, 2013 at 10:20 pm
    Aug 5, 2013 at 5:24 pm
  • Hi, While looking at the pg_restore code, I noticed that while it supports specifying multiple --table options to restore several tables, it does not support multiple --function options. Or --index, ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 26, 2013 at 7:29 pm
    Aug 27, 2013 at 8:31 pm
  • [ moved to hackers ] Based on my research, I am now proposing a new, attached patch which eliminates comma in all places in TRIM, e.g. this is no longer valid either: SELECT trim(BOTH FROM 'abc', ...
    Bruce MomjianBruce Momjian
    Aug 12, 2013 at 2:11 pm
    Aug 21, 2013 at 11:33 am
  • Do we have any attempts of implementation the HTTP server described at http://wiki.postgresql.org/wiki/HTTP_API? It seems like there are design ideas only. Are there any ideas about implementation ...
    Szymon GuzSzymon Guz
    Aug 8, 2013 at 6:44 pm
    Aug 12, 2013 at 4:54 pm
  • Hello, I am looking the effect of having large number of relation files under $PGDATA/base/ (for example, in cases where I choose lower segment size using --with-segsize). Consider a case where I am ...
    Amit LangoteAmit Langote
    Aug 5, 2013 at 6:23 am
    Aug 6, 2013 at 11:06 am
  • Hi all, I understand that setting synchronous_standby_name to '*' means that all priority of standby server are same. and the standby server, which connected to the master server at first, become ...
    Sawada MasahikoSawada Masahiko
    Aug 23, 2013 at 7:42 am
    Aug 30, 2013 at 6:03 am
  • Hello I had to enhance my older project, where XML documents are parsed and created on server side - in PLpgSQL and PLPerl procedures. We would to use a LO API for client server communication, but we ...
    Pavel StehulePavel Stehule
    Aug 10, 2013 at 6:39 am
    Aug 25, 2013 at 3:12 pm
  • A "pg_basebackup -Fp" running on the same system as the target cluster will fail in the presence of tablespaces; it would backup each tablespace to its original path, and those paths are in use ...
    Noah MischNoah Misch
    Aug 1, 2013 at 4:15 pm
    Aug 12, 2013 at 6:39 pm
  • Hi, People, including me, every now and then forget to pass --enable-depend to configure (when not using my own environment). Which then leads to strange errors that cost time to track down... Thus ...
    Andres FreundAndres Freund
    Aug 1, 2013 at 9:10 am
    Aug 6, 2013 at 2:50 am
  • Please find attached a first version of a patch to allow additional "dynamic" shared memory segments; that is, shared memory segments that are created after server startup, live for a period of time, ...
    Robert HaasRobert Haas
    Aug 14, 2013 at 1:09 am
    Aug 31, 2013 at 12:27 pm
  • Hackers, I am trying to do something like this: CREATE TYPE source AS ENUM( 'fred', 'wilma', 'barney', 'betty' ); CREATE EXTENSION btree_gist; CREATE TABLE things ( source source NOT NULL, within ...
    David E. WheelerDavid E. Wheeler
    Aug 20, 2013 at 3:49 pm
    Aug 22, 2013 at 6:16 am
  • As part of routine maintenance monitoring, it is interesting for us to have statistics on the CLUSTER command (timestamp of last run, and number of runs since stat reset) like we have for ...
    Vik FearingVik Fearing
    Aug 8, 2013 at 11:52 am
    Aug 9, 2013 at 10:50 pm
  • I'm currently implementing commit sequence number (CSN) based snapshots and I hit a design decision that I would like to resolve before I have too much code to rewrite. The issue is commit visibility ...
    Ants AasmaAnts Aasma
    Aug 28, 2013 at 2:58 pm
    Aug 29, 2013 at 10:24 pm
  • pg_dump and pg_restore don't behave very nicely when the client and server encodings don't match. Below are three issues that arise from that. All the examples below use a console with a UTF-8 ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 26, 2013 at 3:27 pm
    Aug 28, 2013 at 4:14 am
  • Hello! From time to time when investigating different locking issues using postgres log i have thought that "process x is still waiting for" message could be more informative, for example at the ...
    Tarvi PillessaarTarvi Pillessaar
    Aug 20, 2013 at 4:21 pm
    Aug 27, 2013 at 4:46 pm
  • Hi all Andres and I were going over a patch yesterday and found an unexpected bug in tqual.c while attempting to trigger a hypothesized bug in that patch. A SELECT ... FOR SHARE will incorrectly ...
    Craig RingerCraig Ringer
    Aug 2, 2013 at 5:26 am
    Aug 22, 2013 at 6:12 am
  • I'm having trouble parsing this: ERROR: aggregate functions are not allowed in FROM clause of their own query level The example in the regression tests is: -- LATERAL can be used to put an aggregate ...
    Peter EisentrautPeter Eisentraut
    Aug 8, 2013 at 1:35 am
    Aug 10, 2013 at 1:18 am
  • Hi all, I was experimenting with the idea of moving hot buffer pages from the buffer pool to heap, thus allowing for normal removal of the hot buffer page from the buffer pool and freeing the ...
    Atri SharmaAtri Sharma
    Aug 5, 2013 at 7:36 pm
    Aug 6, 2013 at 4:15 am
  • For many years now, MySQL has a feature called INSERT IGNORE [1]; SQLite has INSERT ON CONFLICT IGNORE [2]; SQL Server has an option called IGNORE_DUP_KEY and Oracle has a hint called ...
    Peter GeogheganPeter Geoghegan
    Aug 30, 2013 at 10:10 pm
    Aug 31, 2013 at 6:34 pm
  • Andres FreundAndres Freund
    Aug 27, 2013 at 2:40 pm
    Aug 29, 2013 at 10:11 am
  • Hey everyone, I'm looking for feedback on a contrib/hstore patch. We've been experiencing slow "@ " queries involving an hstore column that's covered by a Gin index. At the current postgresql git ...
    Blake SmithBlake Smith
    Aug 22, 2013 at 2:55 pm
    Aug 28, 2013 at 5:40 pm
  • Per report of Armin Ronacher, it's not clear how to take a scalar JSON string and unquote it into a regular Postgres "text" value, given what I can see here ...
    Daniel FarinaDaniel Farina
    Aug 24, 2013 at 9:37 pm
    Aug 25, 2013 at 6:14 pm
  • In a thread over in pgsql-performance, Tomas Vondra pointed out that choose_hashed_distinct was sometimes making different choices than choose_hashed_grouping, so that queries like these: select ...
    Tom LaneTom Lane
    Aug 20, 2013 at 9:24 pm
    Aug 21, 2013 at 4:28 pm
  • Hi, I don't see indication that the capability described below exists in Postgres (or any RDBMS), so this is likely a feature request -- For column types that are frequently defined in tables, and ...
    Charles SheridanCharles Sheridan
    Aug 19, 2013 at 1:10 pm
    Aug 19, 2013 at 2:09 pm
  • 1 .\src\backend\utils\cache\relfilenodemap.c(213) : warning C4101: 'isnull' : unreferenced local variable It seems this variable is used only under macro USE_ASSERT_CHECKING, so it is better to ...
    Amit KapilaAmit Kapila
    Aug 18, 2013 at 6:21 am
    Aug 19, 2013 at 5:06 am
  • All, I wanted to highlight the below commit as being a significant enough change that it warrents being seen on -hackers and not just -committers. If you use SSL with libpq, particularly in a ...
    Stephen FrostStephen Frost
    Aug 1, 2013 at 2:24 pm
    Aug 17, 2013 at 12:22 pm
  • Hello, I seem to recall autovacuum changes landing for 9.2.4. Can someone please describe what those changes were and how they could affect usage? JD -- Command Prompt, Inc. - ...
    Joshua D. DrakeJoshua D. Drake
    Aug 5, 2013 at 6:16 pm
    Aug 5, 2013 at 8:23 pm
  • Hi all! While working on upgrading the database of the search system on postgresql.org to 9.2 I noticed that the dumps that pg_dump generates on that system are actually invalid and cannot be ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Aug 18, 2013 at 11:05 am
    Aug 31, 2013 at 10:51 pm
  • Funnily by far the biggest thing I have seen in benchmarks is the CRC32 computation. I plan to brush up my ~3 year old CRC32 reimplementation patch sometime, but afair you had a much better one? I ...
    Andres FreundAndres Freund
    Aug 29, 2013 at 10:30 pm
    Aug 30, 2013 at 1:20 pm
  • Hello, One of my colleagues, who is relatively new to PostgreSQL, asked me if PostgreSQL supports Solaris 11. The reason why he had this question is that the following page says "Solaris 10" instead ...
    MauMauMauMau
    Aug 21, 2013 at 2:29 pm
    Aug 30, 2013 at 9:01 am
Aug 2013
123
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions125
posts1,430
users128
websitepostgresql.org...
irc#postgresql

128 users for August 2013

Tom Lane: 135 posts Andres Freund: 113 posts Stephen Frost: 83 posts Josh Berkus: 77 posts Bruce Momjian: 76 posts Robert Haas: 73 posts Alvaro Herrera: 63 posts Pavel Stehule: 60 posts Peter Eisentraut: 39 posts Dimitri Fontaine: 29 posts Amit Kapila: 27 posts Merlin Moncure: 27 posts Boszormenyi Zoltan: 26 posts David E. Wheeler: 22 posts Michael Paquier: 22 posts Noah Misch: 21 posts Greg Stark: 20 posts Andrew Dunstan: 19 posts Heikki Linnakangas: 19 posts Fujii Masao: 18 posts
show more
Archives