[GENERAL] psql color hostname prompt

2016-04-27 Thread Cal Heldenbrand
#x27; <<< $name ) fi ========== Thank you! -- Cal Heldenbrand

Re: [GENERAL] psql color hostname prompt

2016-04-26 Thread Cal Heldenbrand
st calling the uname(2) and/or gethostname(2) system call. All other remote connections would then fall back to the current %M functionality. ------- Cal Heldenbrand Web Operations at FBS Creators of flexmls <http://flexmls.com>® an

Re: [GENERAL] psql color hostname prompt

2016-04-26 Thread Cal Heldenbrand
Thanks for the input everyone. I'll try to comment on each discussion point: 1) garbled output in large queries I messed around with a few things, and have not been able to recreate any issues. Can you provide a test case for this? Also, any other interesting things about your terminal, like y

[GENERAL] psql color hostname prompt

2016-04-25 Thread Cal Heldenbrand
#x27; <<< $name ) fi ====== Thank you! --- Cal Heldenbrand Web Operations at FBS Creators of flexmls <http://flexmls.com>® and Spark Platform <http://sparkplatform.com> c...@fbsdata.com

Re: [GENERAL] Querying a time range across multiple partitions

2014-09-08 Thread Cal Heldenbrand
On Fri, Sep 5, 2014 at 10:31 AM, Cal Heldenbrand wrote: > >> >> explain analyze select time,event from logins >> where username='bob' and hash='1234' and time > current_date - interval >> '1 week'; >> >> Result (cost=0.0

Re: [GENERAL] Querying a time range across multiple partitions

2014-09-05 Thread Cal Heldenbrand
ata takes about 30 seconds per query anyway... but I thought it'd be nice to speed it up when the difference is milliseconds vs 30 seconds. On Fri, Sep 5, 2014 at 4:17 PM, John R Pierce wrote: > On 9/5/2014 10:31 AM, Cal Heldenbrand wrote: > > Number of child tables: 1581 > &

Re: [GENERAL] Querying a time range across multiple partitions

2014-09-05 Thread Cal Heldenbrand
What about: > explain analyze select time,event from logins > where username='bob' and hash='1234' and time > (current_date - interval > '1 week’)::timestamp without time zone; > > Also, you don’t appear to be having an index that starts from “time”, so > none of the indexes will be particularly

[GENERAL] Querying a time range across multiple partitions

2014-09-05 Thread Cal Heldenbrand
Hi everyone, I'm trying to run a select query from a span of child partitions, separated out in daily tables, in Postgres 9.1.5. The parent looks like this: # \d logins Table "public.logins" Column|Type | Modifiers -+---