Search Postgresql Archives

Re: Does indexing help >= as well as = for integer columns?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: tjo@xxxxxxx
Subject: Re: Does indexing help >= as well as = for integer columns?
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 02 Feb 2005 10:37:40 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx, lists@xxxxxxxxxxxxxxxxxxxxx
Comments: In-reply-to "TJ O'Donnell" <tjo@acm.org> message dated "Wed, 02 Feb 2005 06:51:13 -0800"
In-reply-to: <4200E8E1.6020301@acm.org>
References: <D425483C2C5C9F49B5B7A41F8944154705585B@postal.corporate.connx.com> <1540.209.223.166.104.1106697005.squirrel@gnova.com> <opsk8jtbemth1vuj@musicbox> <41F90AE6.1060801@acm.org> <opsk9slnxrth1vuj@musicbox> <2842.209.223.166.104.1107284205.squirrel@gnova.com> <18111.1107286239@sss.pgh.pa.us> <4200E8E1.6020301@acm.org>
Sender: pgsql-general-owner@xxxxxxxxxxxxxx

"TJ O'Donnell" <tjo@xxxxxxx> writes:
> Last week, I asked about visualizing B-tree "coverage".  I think
> I meant "Can I see the histograms that Analyze creates?"
> Are they available anywhere?

See pg_stats

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: visualizing B-tree index coverage
  - From: Dann Corbit
- Re: visualizing B-tree index coverage
  - From: TJ O'Donnell
- Re: visualizing B-tree index coverage
  - From: PFC
- Re: visualizing B-tree index coverage
  - From: TJ O'Donnell
- Re: visualizing B-tree index coverage
  - From: PFC
- Does indexing help >= as well as = for integer columns?
  - From: TJ O'Donnell
- Re: Does indexing help >= as well as = for integer columns?
  - From: Tom Lane
- Re: Does indexing help >= as well as = for integer columns?
  - From: TJ O'Donnell

Prev by Date: NewsServer down ?
Next by Date: simple case syntax oddity in 8.0.0
Previous by thread: Re: Does indexing help >= as well as = for integer columns?
Next by thread: Re: visualizing B-tree index coverage
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]