PgSql

Streaming Replication: Checkpoint_segment and wal_keep_segmentson standby
On 31/05/10 18:14, Tom Lane wrote: Heikki Linnakangas<heikki.linnakangas(a)enterprisedb.com> writes: The central question is whether checkpoint_segments should trigger restartpoints or not. When PITR and restartpoints were introduced, the answer was "no", on the grounds that when you're doing recovery you... 1 Jun 2010 03:15

[BUGS] BUG #5487: dblink failed with 63 bytes connection names
"Takahiro Itagaki" <itagaki.takahiro(a)oss.ntt.co.jp> wrote: Bug reference: 5487 Logged by: Takahiro Itagaki Email address: itagaki.takahiro(a)oss.ntt.co.jp Description: dblink failed with 63 bytes connection names Details: Contib/dblink module seems to have a bug in han... 2 Jun 2010 22:00

is_absolute_path incorrect on Windows
Magnus Hagander wrote: Here's a thread that incorrectly started on the security list, but really is more about functionality. Looking for comments: I looked into this and it seems to be a serious issue. The function is_absolute_path() is incorrect on Windows. As it's implemented, it considers the follo... 1 Jun 2010 19:44

bitmap-index-scan faster than seq-scan on full-table-scan(gin index)
On 2010-05-31 22:09, Tom Lane wrote: Jesper Krogh<jesper(a)krogh.cc> writes: Conceptually searching for the "full dataset" would always be fastest solved by a seq-scan. The query planner enforces this so much, so not even "enable_seqscan=off" can convince it to to something else. ... Would ... 31 May 2010 17:29

bitmap-index-scan faster than seq-scan on full-table-scan (gin index)
Jesper Krogh <jesper(a)krogh.cc> writes: Conceptually searching for the "full dataset" would always be fastest solved by a seq-scan. The query planner enforces this so much, so not even "enable_seqscan=off" can convince it to to something else. ... Would it be possible to implement the "Filtering" using th... 31 May 2010 16:23

why do we have rd_istemp?
Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: Given "Relation rel", it looks to me like rel->rd_rel->relistemp will always give the same answer as rel->rd_istemp. So why have both? Might be historical --- relistemp is pretty new. Is this a TODO or something we want to clean up? ... 31 May 2010 16:23

improve plpgsql's EXECUTE 'select into' messagewith a hint
Jaime Casanova wrote: Hi, while TFM says that we can use EXECUTE 'select ' INTO instead of the non implemented EXECUTE 'select ... into ', the message in plpgsql fails to say the same thing... seems like a HINT to me Applied with attached patch. Thanks. -- Bruce Momjian <bruce(a)momjian.us> ... 31 May 2010 16:23

INSERT and parentheses
I have added this to the next commit-fest: https://commitfest.postgresql.org/action/commitfest_view?id=6 --------------------------------------------------------------------------- Marko Tiikkaja wrote: Hi, This came up on IRC today and I recall several instances of this during the last two m... 31 May 2010 16:23

9.0b1: "ERROR: btree index keys must be orderedby attribute"
Tom Lane wrote: Ian Barwick <barwick(a)gmail.com> writes: Apologies, slight c&p error; correct version of query: SELECT ov.object_id FROM object_version ov WHERE ov.object_id = 1 AND ov.version =0 AND ov.object_status_id = ( SELECT MAX(ov1.object_status_id) ... 31 May 2010 14:10

[HACKERS] Index only scans
Hi Heikki, Pgsql-Hackers, Sometime back you have started with "Separate Heap Fetch from Index Scan" which was planned to support partial index only scans. Are you still working on it or do you know someone still working on it? We did some development with Gokul's Index Only Patch and have got good performance num... 31 May 2010 13:04