When indexing is needed for a temp table

From: Bo Guo <bo(dot)guo(at)gisticinc(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: When indexing is needed for a temp table
Date: 2025-04-25 16:43:38
Message-ID: CADHFRch76wc6ewguEteMAiwGiCp_Grbk1pueqAb3pa92Cc2dmQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, everyone!

When creating a temporary table for additional sql operations in a stored
function, should I worry about building indexes on the temp table to
increase performance when the temp table's row count exceeds a certain
threshold? If so, is there a rule of thumb for the row count threshold?

Thanks

*Bo *

>

In response to

  • Reindexing at 2025-04-25 05:16:29 from Wasim Devale

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-04-25 22:41:08 Re: When indexing is needed for a temp table
Previous Message Laurenz Albe 2025-04-25 05:57:23 Re: Reindexing