On 8/1/25 20:50, Igor Korot wrote:
Adrian,
If I read the docs correctly, this field indicates whether the
WHERE condition is actually present.
Am I right?
No, it refers to:
https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION
Thx for clarification.
Bu
Adrian,
On Fri, Aug 1, 2025 at 8:13 PM Adrian Klaver wrote:
>
> On 8/1/25 17:06, Igor Korot wrote:
> > Hi, Laurenz,
>
> >
> > I'm looking at the pg_index table and I see it has:
> >
> > [quote]
> > indisexclusion bool
> >
> > If true, this index supports an exclusion constraint
> > [/quote]
> >
>
On Fri, Aug 1, 2025 at 8:06 PM Igor Korot wrote:
>
> If I read the docs correctly, this field indicates whether the
> WHERE condition is actually present.
>
Are you referring to the condition on a partial index? You can get
that using pg_get_expr():
select pg_get_expr(indpred, indrelid) from pg_
On 8/1/25 17:06, Igor Korot wrote:
Hi, Laurenz,
I'm looking at the pg_index table and I see it has:
[quote]
indisexclusion bool
If true, this index supports an exclusion constraint
[/quote]
If I read the docs correctly, this field indicates whether the
WHERE condition is actually present.
Hi, Laurenz,
On Tue, Jul 29, 2025 at 7:07 AM Laurenz Albe wrote:
>
> On Tue, 2025-07-29 at 06:46 -0500, Igor Korot wrote:
> > SELECT
> > t.relname AS table_name,
> > i.relname AS index_name,
> > a.attname AS column_name
> > FROM
> > pg_class t,
> > pg_class i,
> > pg_index
On Tue, Jul 29, 2025, 9:24 AM Laurenz Albe wrote:
> On Tue, 2025-07-29 at 07:18 -0500, Igor Korot wrote:
> > If I have a database for some financial data for the year 2024 in the
> > mydb_2024 and I have current year financial data in the mydb_2025 how
> > can I compare the data?
>
> You connect
On Tue, 2025-07-29 at 07:18 -0500, Igor Korot wrote:
> If I have a database for some financial data for the year 2024 in the
> mydb_2024 and I have current year financial data in the mydb_2025 how
> can I compare the data?
You connect to both and query them both.
Alternatively, you use postgres_f
On Tue, Jul 29, 2025 at 7:07 AM Laurenz Albe wrote:
>
> On Tue, 2025-07-29 at 06:46 -0500, Igor Korot wrote:
> > SELECT
> > t.relname AS table_name,
> > i.relname AS index_name,
> > a.attname AS column_name
> > FROM
> > pg_class t,
> > pg_class i,
> > pg_index ix,
> > p
On Tue, 2025-07-29 at 06:46 -0500, Igor Korot wrote:
> SELECT
> t.relname AS table_name,
> i.relname AS index_name,
> a.attname AS column_name
> FROM
> pg_class t,
> pg_class i,
> pg_index ix,
> pg_attribute a
> WHERE
> t.oid = ix.indrelid AND
> i.oid = ix.indexr
Hi, guys,
On Mon, Jul 28, 2025 at 10:13 AM Laurenz Albe wrote:
>
> On Mon, 2025-07-28 at 08:19 -0500, David Barbour wrote:
> > Couple of suggestions. You might try ChatGPT.
>
> Please don't be insulting. He asked for real information.
I finally formulate my google request and got this:
https:
On Mon, 2025-07-28 at 08:19 -0500, David Barbour wrote:
> Couple of suggestions. You might try ChatGPT.
Please don't be insulting. He asked for real information.
Yours,
Laurenz Albe
Couple of suggestions. You might try ChatGPT. I've had some success using
this tool to uncover improvements to the use of indexes. The other would
be to look at https://explain.depesz.com/. It's pretty self-explanatory.
You run an explain plan and paste the results into the tool and it will run
On Sat, Jul 26, 2025 at 3:13 PM Igor Korot wrote:
>
> I didn't find the sorting for the field.
>
> Can you help?
The pg_index_column_has_property() can provide this information. E.g.,
select pg_index_column_has_property('my_index'::regclass, 2, 'desc');
On Sat, 2025-07-26 at 15:13 -0400, Igor Korot wrote:
> On Sat, Jul 26, 2025, 2:14 PM Christophe Pettus wrote:
> > > I want to know all individual things:
> > > - whether the index is unique.
> > > - what type of index it is
> > > - whether the field is ASC or DESC.
> > > - all other individual ara
Hi, Christopher,
On Sat, Jul 26, 2025, 2:14 PM Christophe Pettus wrote:
>
>
> > I want to know all individual things:
> > - whether the index is unique.
> > - what type of index it is
> > - whether the field is ASC or DESC.
> > - all other individual arams
>
> pg_index is the source for those.
> I want to know all individual things:
> - whether the index is unique.
> - what type of index it is
> - whether the field is ASC or DESC.
> - all other individual arams
pg_index is the source for those. The one exception is the access method for
the index, which is in pg_class.
Adrian,
On Sat, Jul 26, 2025 at 11:08 AM Adrian Klaver
wrote:
>
> On 7/26/25 08:00, Igor Korot wrote:
> > Hi, ALL,
> > Is there a better place to get the info about the index other than
> > https://www.postgresql.org/docs/current/view-pg-indexes.html
>
> What information do you need?
This is the
Adrian Klaver writes:
> On 7/26/25 08:00, Igor Korot wrote:
>> Is there a better place to get the info about the index other than
>> https://www.postgresql.org/docs/current/view-pg-indexes.html
> pg_class:
> https://www.postgresql.org/docs/current/catalog-pg-class.html
> and pg_attribute:
> https
On 7/26/25 08:00, Igor Korot wrote:
Hi, ALL,
Is there a better place to get the info about the index other than
https://www.postgresql.org/docs/current/view-pg-indexes.html
That guy has a full blown CREATE INDEX command and I will need to
parse it to get the info I need.
FYI,
pg_class:
https
On Sat, Jul 26, 2025, 08:00 Igor Korot wrote:
> Hi, ALL,
> Is there a better place to get the info about the index other than
> https://www.postgresql.org/docs/current/view-pg-indexes.html
>
> That guy has a full blown CREATE INDEX command and I will need to
> parse it to get the info I need.
>
On Sat, 26 Jul 2025, 17:00 Igor Korot, wrote:
> Hi, ALL,
> Is there a better place to get the info about the index other than
> https://www.postgresql.org/docs/current/view-pg-indexes.html
>
> That guy has a full blown CREATE INDEX command and I will need to
> parse it to get the info I need.
>
>
On 7/26/25 08:00, Igor Korot wrote:
Hi, ALL,
Is there a better place to get the info about the index other than
https://www.postgresql.org/docs/current/view-pg-indexes.html
What information do you need?
That guy has a full blown CREATE INDEX command and I will need to
parse it to get the inf
22 matches
Mail list logo
