Re: [GENERAL] The first dedicated PostgreSQL forum

I've used lists where the the line between forum and mailing list is blurred. See: http://www.cocoabuilder.com/ This is actually a web interface for a couple of mailing lists, and is a great tool for searching past posts. You can't post to the web site though - it is strictly a third-party we

[GENERAL] Explicitly adding a table to a schema.

Hi, I have a database where I wasn't explicitly using schemas when I started it (i.e. everything was simply under "public"). I've since created several schemas and renamed the "public" schema to something else. When I look at the definitions (in PGAdmin III), the CREATE statement for the old ta

[GENERAL] Radial searches of cartesian points?

Hi, I have a data set of several hundred thousand points. Each point is saved as a three dimensional coordinate, i.e. (x, y, z). What I'd like to do is given a point in that space, get a list of all of the points in the table within some radius. I'm familiar with the q3c package that does this

[GENERAL] Glacially slow nested SELECT

Hello all, I have a query that is extraordinarily slow but I don't know why. It crosses a many-to-many join table and looks like this: SELECT * FROM spview WHERE id IN (SELECT signal_profile_id FROM track_to_signal_profile WHERE track_id = 19510985); The three tables are: track <-> track