[GENERAL] having two database clusters?

Is it possible to create two connections to two different database clusters on the same machine.

Re: [GENERAL] having two database clusters?

On 23/12/2008 14:03, Jais Mathew wrote: > Is it possible to create two connections to two different database > clusters on the same machine. Surely - just run them on different ports. Ray. -- Raymond O'Donnell, Director of Music, Ga

Re: [GENERAL] Finding foreign keys that are missing indexes

plu tard writes: > I'm aware that if you create a foreign key constraint, no indexes are > automatically created. > I would like to find a way to programatically inspect all my foreign keys and > identify possibly missing indexes on either table (either the table defining > the constraint or t

[GENERAL] timestamp differences

I have a timestamp column that I want to compare with current timestamp. I want to get all rows that are less than 10 minutes old. I have searched but can not find how to do this, any pointers? regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] timestamp differences

On Sunday 28 December 2008 1:40:28 pm Garry Saddington wrote: > I have a timestamp column that I want to compare with current timestamp. > I want to get all rows that are less than 10 minutes old. I have searched > but can not find how to do this, any pointers? > regards > Garry select * from foo

Re: [GENERAL] timestamp differences

On Sunday 28 December 2008 1:53:30 pm Adrian Klaver wrote: > On Sunday 28 December 2008 1:40:28 pm Garry Saddington wrote: > > I have a timestamp column that I want to compare with current timestamp. > > I want to get all rows that are less than 10 minutes old. I have searched > > but can not find

Re: [GENERAL] Finding foreign keys that are missing indexes

> plu tard writes: > > I'm aware that if you create a foreign key constraint, no indexes are > > automatically created. > > I would like to find a way to programatically inspect all my foreign keys > > and identify possibly missing indexes on either table (either the table > > defining the con

Re: [GENERAL] Finding foreign keys that are missing indexes

plu 12 writes: > Technically, would we also need to worry about constraints that are a prefix > of an index? e.g., that an index on (f1, f2) would be usable for a constraint > on (f1)? I guess you could, but it seems overly complicated for something that's just meant to locate trouble spots.