[GENERAL] partitioning a table containing millions of records

Hi, I have a question concerning the topic patitioning. I have a table with millions of records and I would like to partition it. I have already read the documentation but it could not answer my question. My question is, the following: Do I have to create the master and child tables and so o

Re: [GENERAL] partitioning a table containing millions of records

want to split that into groups if you have many millions of rows. On Sat, Oct 25, 2008 at 6:47 AM, Andreas Jochem <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Hi, I have a question concerning the topic patitioning. I have a table with millions of records and I w

[GENERAL] nearest neighbor search from xyz coordinates

Hello, I have a table containing x y z coordinates. But I have no geometry column? Is it possible to find the k nearest neighbors of any point. Is there something like a kd-tree Index in postgres??? I know, if i had a geometry column I could make use of the distance function to find the k nea

Re: [GENERAL] Execute Shell script after insert

You can write the insert into command in a shellscript by using #!/bin/bash psql -c "INSERT INTO " -U mkdir $1 Anderson dos Santos Donda wrote: Is there a way to execute a simple shell script in server after execute INSERT INTO ? Example? INSERT INTO clients (name) VALUES (