Re: Poor query performance - Mailing list pgsql-performance

From Alex
Subject Re: Poor query performance
Date
Msg-id dcf7449f-dc3b-4046-a11e-7ed1f8351cd9@m11g2000yqh.googlegroups.com
Whole thread Raw
In response to Re: Poor query performance  (Alex <alex@liivid.com>)
List pgsql-performance
>
> How is the index  sl_city_etc defined?
>

 Index "public.sl_city_etc"
    Column    |            Type
--------------+-----------------------------
 city         | text
 listing_type | text
 post_time    | timestamp without time zone
 bedrooms     | integer
 region       | text
 geo_lat      | integer
 geo_lon      | integer
btree, for table "public.source_listings"

pgsql-performance by date:

Previous
From: Suvankar Roy
Date:
Subject: Re: Performance comparison between Postgres and Greenplum
Next
From: Alex
Date:
Subject: Re: Poor query performance