Questions tagged [stado]

Stado is a fork of the open sourced and abandoned GridSQL project. It is an auto-sharding and query distribution system for PostgreSQL.

3 questions

vote

1 answer

Exceptions when creating a trigger in PostgreSQL 9.1

I use PostgreSQL 9.1 with PostGIS 1.5. I'm trying to get this trigger function to work in terminal (Ubuntu): CREATE FUNCTION insert_trigger() RETURNS trigger AS $insert_trigger$ BEGIN IF ( NEW.id >= 10 AND NEW.id < 100 ) THEN INSERT INTO…

asked Mar 30 '14 at 17:25

Shadin

1,867
5
26
37

votes

2 answers

Clustered DB - Stado - Slow first query

Using PostgreSQL in a clustered database (stado) on two nodes. I managed to configure stado coordinator and nodes agents successfully but when I try running a heavy query, the first time it takes too long to show results then after that it was…

database postgresql caching database-performance stado

asked May 17 '14 at 20:48

Shadin

1,867
5
26
37

votes

2 answers

Running PostGIS Commands on Clustered DB

Using Postgresql in clustered database (stado) on two nodes, I want to test this query: select id,position,timestamp from table t1 WHERE id!=0 AND ST_Intersects ((Select ST_Buffer_Meters(ST_SetSRID(ST_MakePoint(61.4019,15.218205), 4326)…

sql database postgresql postgis stado

asked Apr 06 '14 at 19:39

Shadin

1,867
5
26
37