Anthony Presley writes:
> I have tried setting the statistics on employee.user_id to be 100 and 1000,
> and the rest are the default (100).
> I've run both an "ANALYZE" and a "VACUUM ANALYZE" on the production system -
> both "generally", and on each of the above tables (employee, app_user,
> loc
Hi all
I'd like to tune the following hstore-related query which selects all
Zoos from table osm_point:
SELECT osm_id, name, tags
FROM osm_point
WHERE tags @> hstore('tourism','zoo')
ORDER BY name;
... given the following table and indexes definition:
CREATE TABLE osm_point (
osm_id int
On Sat, Oct 22, 2011 at 10:58 AM, Tom Lane wrote:
> Anthony Presley writes:
> > We have a dev machine running 9.0.1 (an i3 laptop, with a regular hard
> disk,
> > with 4GB of RAM, and a mostly untuned postgresql.conf file). The changed
> > lines are:
> > shared_buffers = 512MB
> > temp_buff
Anthony Presley writes:
> We have a dev machine running 9.0.1 (an i3 laptop, with a regular hard disk,
> with 4GB of RAM, and a mostly untuned postgresql.conf file). The changed
> lines are:
> shared_buffers = 512MB
> temp_buffers = 48MB
> work_mem = 32MB
> maintenance_work_mem = 348MB
>
