1 GB of ram is quite small.
I think it is worth to try creating an index on a combination of
columns(lat, lng).
So that Bitmap Heap Scan would be omitted.
>
> QUERY
>
> SELECT COUNT(*) FROM "occurrences" WHERE ("lat" >= -27.91550355958 AND "lat"
> <= -27.015680440420002 AND "lng" >= 152.13307044728307 AND "lng" <=
> 153.03137355271693 AND "category_id" = 1 AND (ST_Intersects(
> ST_Buffer(ST_PointFromText('POINT(152.58 -27.465592)')::geograph
Hi,
I have following table definition with 6209888 rows in it. It stores the
occurrences of species in various regions.
*TABLE DEFINITION*
Column| Type |Modifiers
--++-