Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mvRF4-0001qA-4v for pgsql-www@arkaria.postgresql.org; Thu, 09 Dec 2021 21:46:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mvRF3-0002Dk-1U for pgsql-www@arkaria.postgresql.org; Thu, 09 Dec 2021 21:46:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mvQI3-0007UF-DO for pgsql-www@lists.postgresql.org; Thu, 09 Dec 2021 20:45:19 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mvQI0-0004qq-Qe for pgsql-www@postgresql.org; Thu, 09 Dec 2021 20:45:18 +0000 Received: by mail-ed1-x534.google.com with SMTP id g14so22800671edb.8 for ; Thu, 09 Dec 2021 12:45:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=68c3WkUZ9P8DOWGoFU7uTSQ0Hjy61Wmr+ug58koV/+o=; b=AFhv88nKr3fSN7XSF/FGkjyaJPgqYX/bRjKXvKwj5V391+X1YoIn+DvMC/UTWJVQVj 57hcuLOqaIpjxSErj7aRax6ptPAfG1tD8n4y4eLfMs1ev3Nk1hG5Q/TrF1na4usBN8qw gRjT2fCcdPwX8SEyiXm0vs5FuTmE6O5hIDYxKJfLJvyquNJyAuIfzLI0ijH0gkq1goBw 987YPG7B5cxbhTyGkR7EAn1yFMHorO9G+FbPddPGMN+xkPUA1fq3NlI7kj5NACDjeok2 p8uRedlVc6yRybJRUdik+cIwBpa/WX2vEKBh4ZhIdjRjrGwpRqqX8PfaQQkhJA2vSWwU uv8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=68c3WkUZ9P8DOWGoFU7uTSQ0Hjy61Wmr+ug58koV/+o=; b=E8N5Ybr03MX2a0owZ1z5q/JMki/Vr42Hl6oB1CfYyf904oZiX6MCs872jE6kKlplND menQtyqNHQkdoIO4hLmZa16v4bvzvTCFX4rDcyuFehVcSeJl0LyuMb3OECq6DO/60gki UEAUk7InxNxPekkHc/Ujj3gBhkQswdBRct3rZhT8zDWwvbfz0fMR1hOMfZvDN5ix4UJZ k49FX/0/mwWS/wyxpfAr41RtB004AU9oyUJoc0orvCb9tYWi72xLz7a4sd5Oiam+gFNS pMFPwq6/D+5/IrzLznvGSt+rwZsu6vGnxngPs8+DJDIBLBy5MzTwz1/ra5iQ1JQAnmO6 YgiQ== X-Gm-Message-State: AOAM531fuub5cQDGUosNQOwMeI/yobYT6aHxvho4grA6gHDkFbQbwSW7 BoH86EPyrGh7rTGo+br+3+D0TuOYuubj2ikkUmijGjoSDFE= X-Google-Smtp-Source: ABdhPJwzO1EJvJ/EBsLffaSU76FbZ1/UPU7FnNDlcy7MUBEqjxosmdwOxkp5geZG4nlICbZEON9ryzoJGp7HZnm0q0Y= X-Received: by 2002:a17:907:7094:: with SMTP id yj20mr18699674ejb.265.1639082715215; Thu, 09 Dec 2021 12:45:15 -0800 (PST) MIME-Version: 1.0 From: X L Date: Thu, 9 Dec 2021 15:45:04 -0500 Message-ID: Subject: Wiki editor request To: pgsql-www@postgresql.org Content-Type: multipart/alternative; boundary="000000000000ff7bbb05d2bcae41" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ff7bbb05d2bcae41 Content-Type: text/plain; charset="UTF-8" Hello, I would like to request editor access to the PostgreSQL Wiki. My username is xinyuliu and I would like to add to the page https://wiki.postgresql.org/wiki/Performance_Optimization a list of potential optimization techniques. In the past, we submitted this kind of issues as bug reports (e.g., BUG #16625 ) describing how PostgreSQL may manifest suboptimal runtime performance for certain query patterns, which suggests missing optimizations. However, the developer who responded to our reports suggested reporting these issues as missing optimisations on the Wiki page instead. Furthermore, we also noticed that users could be unaware of these issues and inquire about possible workarounds , which would be a further reason to provide this information on the Wiki. The Wiki would also provide a forum for developers and users to discuss opportunities for improving the existing query optimizer. I am looking forward to your response and would be happy to provide any additional information that you may need. Thank you, Xinyu Liu --000000000000ff7bbb05d2bcae41 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hello,


I would like t= o request editor access to the PostgreSQL Wiki. My username is xinyuliu and I would like to add to the page = https://wiki.postgresql.org/wiki/Performance_Opti= mization=C2=A0 = a list of potential optimization techniques.


In the past, we submitted this kind of iss= ues as bug reports (e.g., BUG #16625) describing how PostgreSQL may manifest suboptima= l runtime performance for certain query patterns, which suggests missing op= timizations. However, the developer who responded to our reports suggested = reporting these issues as missing optimisations on the Wiki page instead.= =C2=A0


Furth= ermore, we also noticed that users could be unaware of these issues and inquire about possible workarounds, which would be a further re= ason to provide this information on the Wiki. The Wiki would also provide a= forum for developers and users to discuss opportunities for improving the = existing query optimizer.


I am looking forward to your response and would be happy to p= rovide any additional information that you may need.


Thank you,

Xinyu Liu


--000000000000ff7bbb05d2bcae41--