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 1pcchp-0002WX-KO for pdxpug@arkaria.postgresql.org; Thu, 16 Mar 2023 01:47:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pccho-0002BG-Ej for pdxpug@arkaria.postgresql.org; Thu, 16 Mar 2023 01:47:00 +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 1pccho-0002B7-76 for pdxpug@lists.postgresql.org; Thu, 16 Mar 2023 01:47:00 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pcchl-0003ux-QG for pdxpug@lists.postgresql.org; Thu, 16 Mar 2023 01:46:59 +0000 Received: by mail-pj1-x1033.google.com with SMTP id d13so261339pjh.0 for ; Wed, 15 Mar 2023 18:46:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678931216; h=content-transfer-encoding:content-disposition:mime-version :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=1z4a4Zz4PB5nUGW2XpAyYs6cp4ieEGUY4ZBelFhU3ck=; b=piVG/GiX+WwHM94mmM6tdyFoJEFh2ZtfkJWFQeydjDmf8KoJP9oppO+ZH1XN/4hQKh VSWp8vf10U+4HvuhcbTVvRUoTeXdaL/5oJAIBdwOXGwJOOK4ZkL4zKOLVwl301U6nonN b+c1dXXH2RdcTABSNQzVNIZSOf576DcDT36XSYmUWUY/um7+eYoxNfhoe4TwnDPSjYVb yhTqBpEKdETs8NgjrLABGhp0jIe8bA47MnNsgAnsZniqpCEwwrSedy7XaeDWpOGQYlo6 7cEfERZdjhPfCd8ln26YvUXoM12q7ZcXMEEqAh+Gk3q2IZ3tYdMv04igX9CdFkWWCP3D RBKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678931216; h=content-transfer-encoding:content-disposition:mime-version :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=1z4a4Zz4PB5nUGW2XpAyYs6cp4ieEGUY4ZBelFhU3ck=; b=oUbssp1I1wQdyM3Ee0jveUpjq47sC+EgiadWFAJ5f0PyjEl1TVUNl/jn84w0Yi1Q1D 1geWZeetNJydQHAAT1qU0eeVFo7wq/mwM0ybbrpwmed9q4vUxh7+DlZOOnYnx0eJOor7 AW+1RTLurFxTXpb48qvo/hunr2Q01Y+Tv4BxLoxhHhHDiwVQknolYbf4CzR24xHCEcih wILZSCRI9YRfVd/i6LjETv0AlgvV80mh8Zh1woZemUqLjwsh5oWPEKwMl954iuX303MR BBZ26pAbsN5839Tm8jHUHVv4VCI4iHnOJq1MpN/uCAUBovD9JdcLGRKDC8TfGEGrjHjV jcMQ== X-Gm-Message-State: AO0yUKU//fuiyyrmO4sY71Gw0TTU2ITPzPq6xSysj9pJC5YtIKIRRezz z+wAls/K23rdxY+36JldtoiIzfB3YyI= X-Google-Smtp-Source: AK7set/BNqvlyVUqXSMqkbp6Y5rj+iHMq5lwAOGs6B403gOeWq/DF3CbBFEpNXrACzIeAQB7t5exzA== X-Received: by 2002:a17:903:124d:b0:19e:8566:ea86 with SMTP id u13-20020a170903124d00b0019e8566ea86mr1740671plh.62.1678931216303; Wed, 15 Mar 2023 18:46:56 -0700 (PDT) Received: from moubin (97-120-35-152.ptld.qwest.net. [97.120.35.152]) by smtp.gmail.com with ESMTPSA id b10-20020a170902a9ca00b00185402cfedesm210913plr.246.2023.03.15.18.46.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 15 Mar 2023 18:46:55 -0700 (PDT) Date: Wed, 15 Mar 2023 18:46:53 -0700 From: Mark Wong To: pdxpug@lists.postgresql.org Cc: Grant Holly Subject: Thursday March 16, 2023, Meetup: Know Your Index Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 2023 March 16th Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders. Speaker: Grant Holly Postgres has many different kinds of indices for different use cases. Let’s take a look at the different options that come with indexing your data. We will also look at index trade-offs because, as you know, there’s no free lunch. This talk is for all experience levels. Bring your questions and stories. We are looking forward to seeing you there. -- Mark Wong EDB https://enterprisedb.com