Hi,
On Jan 5, 2012, at 12:54 PM, Merlin Moncure wrote:
> see:
> http://www.postgresql.org/docs/9.1/interactive/cube.html
>
> and pay special attention to gist indexing portions. cube only
> indexes box operations, but you can cull the sphere using 3d distance
> formula for points between inner
Hi,
On Nov 4, 2011, at 2:09 PM, Adam Cornett wrote:
> You can use ALTER TABLE
> (http://www.postgresql.org/docs/current/static/sql-altertable.html) to set
> the schema of existing tables:
> ALTER TABLE foo SET SCHEMA bar
Thanks. I did try that, but that command moves the table to a different s
Thanks Scott and Matthias for your replies!
On Nov 11, 2010, at 5:29 PM, Scott Marlowe wrote:
> Next time, post questions to the slony mailing list if you get stuck,
> we're pretty helpful over there. also look at some of the "my first
> replicated db" tutorials for it.
> Slony, btw, supports re
Hello,
I am interested in sharing/replicating data between different databases, and
I'd like to ask if what I'd like to do is possible in postgresql. I have read a
fair amount of documentation and was looking forward to PostgreSQL 9, but I
don't think it will do for me what I want.
I have an a
On 15 Jan 2007, at 16:21, Tom Lane wrote:
[EMAIL PROTECTED] writes:
I have a query that is extraordinarily slow but I don't know why.
It looks like spview is a view with an embedded ORDER BY? IIRC that
prevents any meaningful optimization of joins to it --- and
WHERE-IN-sub-SELECT is a kind
