David G Johnston writes:
> Just looking for recollection regarding why these were omitted initially and
> if anyone has concerned adding them in follow-up.
My recollection is that RANGE requires some data-type-specific behavior
that we don't have any provision for in PG's datatype extension frame
ex. avg(value) over (order by date range interval '6' day preceding)
Source:
http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf
Page 9, slide 17
The SELECT SQL command page mentions standard aspects of window frame
clause
On 27/09/14 11:56, John R Pierce wrote:
On 9/26/2014 4:40 PM, John R Pierce wrote:
I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such
problems. 15 random alphanumerics is already plenty complex,
62^15th possible combinations, without needing to mix in special
characters.
$ mkp
On 9/26/2014 4:40 PM, John R Pierce wrote:
I'd consider using `mkpasswd -l 15 -s 0` just to avoid any such
problems. 15 random alphanumerics is already plenty complex, 62^15th
possible combinations, without needing to mix in special characters.
$ mkpasswd -l 15 -s 0
eec1kj7ZsthlYmh
btw, t
On 09/26/2014 04:32 PM, Nelson Green wrote:
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver
Doubling the quote seems to work here.
Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became
obvious
that I was doing something wrong. And yes, in the end you were right.
Doubling
On 9/26/2014 4:32 PM, Nelson Green wrote:
Thanks Bosco, DrakoRod, and Adrian. Between the three of you it became
obvious
that I was doing something wrong. And yes, in the end you were right.
Doubling
the quote does indeed work.
It turns out it this particular password also had a \ in it, and
On Fri, Sep 26, 2014 at 5:51 PM, Adrian Klaver
wrote:
> On 09/26/2014 12:58 PM, Nelson Green wrote:
>
>> Hello all,
>>
>> I am setting up a streaming replication stand-by, and the replication
>> role password has a single quote in it. I am unable to properly
>> reference the password in the conni
On 09/26/2014 12:58 PM, Nelson Green wrote:
Hello all,
I am setting up a streaming replication stand-by, and the replication
role password has a single quote in it. I am unable to properly
reference the password in the conninfo setting of recovery.conf so it
will authenticate to the master. Doub
We have a similar timeseries database approaching 500m records.
We partition the main tables (much like your events) into one year subsets,
with a clustered index on timestamp for all but the live year.
https://blog.engineyard.com/2013/scaling-postgresql-performance-table-partitioning
http://www
Hi!
Have you tried escape the Single or Double quote? Maybe this information can
help you:
http://stackoverflow.com/questions/12316953/insert-varchar-with-single-quotes-in-postgresql
http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html
Best Regards!
-
Dame un poco de fe,
On 27/09/14 09:02, Jonathan Vanasco wrote:
I have a growing database with millions of rows that track resources against an
event stream.
i have a few handfuls of queries that interact with this stream in a variety of
ways, and I have managed to drop things down from 70s to 3.5s on full scans a
I have a growing database with millions of rows that track resources against an
event stream.
i have a few handfuls of queries that interact with this stream in a variety of
ways, and I have managed to drop things down from 70s to 3.5s on full scans and
offer .05s partial scans.
no matter
On 09/26/14 12:58, Nelson Green wrote:
>
> I am setting up a streaming replication stand-by, and the replication
> role password has a single quote in it. I am unable to properly
> reference the password in the conninfo setting of recovery.conf so it
> will authenticate to the master. Doubling the
Hello all,
I am setting up a streaming replication stand-by, and the replication role
password has a single quote in it. I am unable to properly reference the
password in the conninfo setting of recovery.conf so it will authenticate
to the master. Doubling the quote gives me a syntax error, and es
Roopeshakumar Narayansa Shalgar (rshalgar) wrote
> bash-3.2# du -h
> 4.0K./pg_stat
> 6.2M./base/12026
> 198M./base/16384
> 6.3M./base/12031
> 6.3M./base/1
> 216M./base
> 24K ./pg_stat_tmp
> [...]
> 129M./pg_xlog
> 4.0K./pg_tblspc
> 12K ./pg_notify
> 4.0K.
On 25/09/2014 11:44, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
> Hi,
>
>
>
> I am using version 9.3.1 and see the “no space device error” even though
> there is enough space (99% free) on my disk.
>
>
>
> Error: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space
> left
On 25/09/2014 11:44, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
> Hi,
>
>
>
> I am using version 9.3.1 and see the “no space device error” even though
> there is enough space (99% free) on my disk.
>
>
>
> Error: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space
> left
Hi,
I am using version 9.3.1 and see the "no space device error" even though there
is enough space (99% free) on my disk.
Error: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on
device
I want to know whether this is a bug and if yes whether fix or workaround is
availabl
A bit more info:
> What if there were changes on the master that didn't get replicated
> before I originally shut it down?
It looks like Ubuntu's init.d script does a "fast" shutdown, i.e.
SIGINT on this page:
http://www.postgresql.org/docs/9.3/static/server-shutdown.html
I can't tell from the
Hi All,
I have Postgres 9.3 on Ubuntu 14.04 set up in a master/slave
configuration with streaming replication. On the master I ran `sudo
service postgresql stop` and then on the slave I ran `sudo touch
$trigger_file`. Now the slave seems to be running fine, but I'm trying
to figure out the process
--
Derek Giri
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Sep 19, 2014 at 1:23 PM, Dev Kumkar wrote:
> Apologies for the delay, was working/troubleshooting same issue and was
> away from my emails. :(
> Regards...
>
Received the database with huge pg_multixact directory of size 21G and
there are ~82,000 files in "pg_multixact/members" and 202 f
On Tue, Sep 23, 2014 at 9:24 PM, Bill Moran
wrote:
> On Tue, 23 Sep 2014 14:12:22 +0200
> Thomas Kellerer wrote:
>
> > Sameer Kumar schrieb am 23.09.2014 um 07:24:
> > > I am working with a vendor and planning to deploy their application
> > > on PostgreSQL as backend. They have cautioned the cu
23 matches
Mail list logo
