Re: [GENERAL] Indexing large table of coordinates with GiST

2015-01-15 Thread Nathan Clayton
On 1/15/2015 12:36 PM, Daniel Begin wrote: Thank, there is a lot of potential ways to resolve this problem! For Rob, here is a bit of context concerning my IT environment… Windows 7 64b Desktop, running with an Intel i7 core and 16GB ram. The PostgreSQL 9.3 database is stored on a 3TB

Re: [GENERAL] Success stories of PostgreSQL implementations in different companies

2013-05-23 Thread Nathan Clayton
On Thu, May 23, 2013 at 2:51 PM, Steve Crawford scrawf...@pinpointresearch.com wrote: On 05/23/2013 02:36 PM, Oscar Calderon wrote: Hi, this question isn't technical, but is very important for me to know. Currently, here in El Salvador our company brings PostgreSQL support, but Oracle and

Re: [GENERAL] Yet Another Timestamp Question: Time Defaults

2013-01-21 Thread Nathan Clayton
Monday, January 21, 2013, 8:56:38 PM, you wrote: Except for days that are 23-hours long, or 25, or other (it's a big world with all sorts of timezone rules). The day's length may change but I don't believe there is anywhere that allows for the local time of day to equal or be greater than

Re: [GENERAL] query by partial timestamp

2013-01-09 Thread Nathan Clayton
On Jan 8, 2013 6:15 PM, Kirk Wythers wythe...@umn.edu wrote: On Jan 8, 2013, at 6:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: The OP didn't suggest how many years his data covers, but it's quite possible that pulling a full year's worth of data will read enough of the table that there's no

Re: [GENERAL] large database

2012-12-16 Thread Nathan Clayton
On Dec 11, 2012 2:25 PM, Adrian Klaver adrian.kla...@gmail.com wrote: On 12/11/2012 01:58 PM, Mihai Popa wrote: On Tue, 2012-12-11 at 10:00 -0800, Jeff Janes wrote: On Mon, Dec 10, 2012 at 12:26 PM, Mihai Popa mi...@lattica.com wrote: Hi, I've recently inherited a project that involves