Re: [PERFORM] Fwd: How to create a multi-column index with 2 dates using 'gist'?

2009-08-26 Thread Matthew Wakeling
On Tue, 25 Aug 2009, Fred Janon wrote: Asking the Performance people as well, since I didn't get any answer from General... I have been unable to create a multi column index with 2 integers as well, same error as the one I get with 2 dates. ERROR: data type date has no default operator clas

[PERFORM] Fwd: How to create a multi-column index with 2 dates using 'gist'?

2009-08-25 Thread Fred Janon
Asking the Performance people as well, since I didn't get any answer from General... I have been unable to create a multi column index with 2 integers as well, same error as the one I get with 2 dates. Thanks Fred -- Forwarded message -- From: Fred Janon Date: Mon, Aug 24, 2009

Re: [PERFORM] [Fwd: ] How

2007-04-27 Thread Richard Huxton
Siddharth Anand wrote: Hi! I read the link below and am puzzled by or curious about something. http://www.postgresql.org/docs/8.1/interactive/datatype-character.html The Tip below is intriguing "Tip: There are no performance differences between these three types, apart from the increased stora

[PERFORM] [Fwd: ] How

2007-04-27 Thread Siddharth Anand
Hi! I read the link below and am puzzled by or curious about something. http://www.postgresql.org/docs/8.1/interactive/datatype-character.html The Tip below is intriguing "Tip: There are no performance differences between these three types, apart from the increased storage size when using the bl