PgSql
in [SQL]
|
[HACKERS] Query execution plan from 8.3 -> 8.4 Getting significantly lower performance on a specific query after upgrading from 8.3 -> 8.4 (windows). I'm not expecting a quick fix from the mail lists, but I would appreciate any indications as to where else I could look or what tools I could employ to investigae further. Details below. -Brendan ... 12 May 2010 10:15
[HACKERS] HS starting snapshot corrections Tom pointed out two errors that could effect the HS startup code, which is fairly subtle. Attached patch is small with these changes * adds new section comment as posted to hackers earlier * adds comments to other functions * makes minor corrections to a few existing comments * fixes the two bugs observed by ... 12 May 2010 06:57
SHARE locks vs. DELETE in SERIALIZABLE mode (Was: Partitioning/inherited tables vs FKs) On 5/11/2010 12:39 PM, Florian Pflug wrote: On May 11, 2010, at 17:04 , Robert Haas wrote: 2010/5/11 Florian Pflug <fgp(a)phlo.org>: C1: BEGIN C1: INSERT INTO child (parent_id) VALUES (0) C2: BEGIN C2: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE C2: SELECT TRUE -- Take snapshot *before* C... 11 May 2010 14:32
[HACKERS] C++ keyword in utils/rbtree.h src/tools/pginclude/cpluspluscheck says: ../utils/rbtree.h:21: error: expected ',' or '...' before 'new' Can we rename the "new" to something like "new_whateveritis"? And what is it? :-) -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http:/... 11 May 2010 14:32
SHARE locks vs. DELETE in SERIALIZABLE mode (Was: Partitioning/inherited tables vs FKs) On May 11, 2010, at 17:04 , Robert Haas wrote: 2010/5/11 Florian Pflug <fgp(a)phlo.org>: C1: BEGIN C1: INSERT INTO child (parent_id) VALUES (0) C2: BEGIN C2: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE C2: SELECT TRUE -- Take snapshot *before* C1 commits C1: COMMIT C2: DELETE FROM parent W... 11 May 2010 13:24
[HACKERS] SHARE locks vs. DELETE in SERIALIZABLE mode (Was: Partitioning/inherited tables vs FKs) On May 11, 2010, at 13:29 , Robert Haas wrote: On Tue, May 11, 2010 at 2:16 AM, Dmitry Fefelov <fozzy(a)ac-sw.com> wrote: The referential integrity triggers contain some extra magic that isn't easily simulatable in userland, and that is necessary to make the foreign key constraints airtight. We've disc... 11 May 2010 11:10
List traffic Simon Riggs wrote: Traffic on the PostgreSQL lists is very high now and I freely admit that reading every email is simply not possible for me, even the ones that mention topics that keyword searches tell me are of potential interest. If anybody knows of a bug or suspected bug in my code, I have no p... 28 May 2010 18:10
Patch for PKST timezone Aftab Hussain <aftab.se(a)gmail.com> wrote: Please accept attached patch for the following problem. This patch has not been replied, but I can reproduce the error with: =# SET timezone = 'Asia/Karachi'; =# SELECT timeofday()::timestamptz; ERROR: invalid input syntax for type timestamp with time zone: "Tue M... 11 May 2010 19:02
Make archiver check for SIGHUP more often? On Tue, May 11, 2010 at 10:13 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: There's a complaint over here http://archives.postgresql.org/pgsql-general/2010-05/msg00365.php about the archiver process not being very swift to adopt a new value of archive_command. This is because it only reacts to SIGHUP once per... 11 May 2010 01:23
[HACKERS] Invitation to connect on LinkedIn LinkedIn ------------Carlos Jordão souhaite se connecter à vous sur LinkedIn : ------------------------------------------ Amine, I'd like to add you to my professional network on LinkedIn. - Carlos Accepter l'invitation de Carlos Jordão http://www.linkedin.com/e/VWCdriNHrcXMfYpwEG6pcCKmodzjIoHmhgnzwr... 11 May 2010 00:18 |