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 extern

Re: [GENERAL] query by partial timestamp

2013-01-09 Thread Nathan Clayton
On Jan 8, 2013 6:15 PM, "Kirk Wythers" wrote: > > > On Jan 8, 2013, at 6:48 PM, Tom Lane 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 point in worrying abou

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 > greate

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 >> Ora

Re: [GENERAL] large database

2012-12-16 Thread Nathan Clayton
On Dec 11, 2012 2:25 PM, "Adrian Klaver" 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 wrote: Hi, I've recently inherited a project that involves importing a