Re: Poor query performance

From: Alex <alex(at)liivid(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor query performance
Date: 2009-07-15 07:50:42
Message-ID: dcf7449f-dc3b-4046-a11e-7ed1f8351cd9@m11g2000yqh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2009-07-15 08:22:26 Re: Poor query performance
Previous Message Greg Stark 2009-07-15 06:52:40 Re: Poor query performance