e/contrib and /share/extension directories under the
> PostgreSQL main directory to see what is available for your version.
>
> On Fri, Jun 12, 2015 at 8:22 AM, Michael Shapiro
> wrote:
>
>> I am wondering if the contributed module will always be part of
>> Postgres? D
subsequent versions of Postgres?
Are there any plans to make a built-in datatype, like ,
o, or the various Geometric Types (eg, )?
Michael Shapiro
Senior Systems Engineer
National Center for Supercomputing Applications (NCSA)
University of Illinois, Urbana-Champaign (UIUC)
I have a table called jobs with ~17 millions records. Without an index on
the queue column, the following query
select count(*) from jobs where lower(queue) = 'normal'
found ~2.6 millions records in 10160ms
With the following index:
create index lower_queue on jobs (lower(queue))
th
