[GENERAL] json_array_elements_text?

Hello, I'm trying to unpack a json array into it's constituent text values so I can join them to a table. I can successfully unpack json values, but am having trouble converting these to text so I can cast them to the UUIDs needed for the join. http://dba.stackexchange.com/questions/54283/how-to-

Re: [GENERAL] Correct query to check streaming replication lag

On Tue, Jan 14, 2014 at 2:31 PM, Granthana Biswas wrote: > Can anyone please tell me which of the following is the correct > replication lag query to find streaming replication lag in seconds? > > IMHO none is 'correct'. :-) 1. SELECT extract(seconds from (now() - pg_last_xact_replay_timestamp())

Re: [GENERAL] Correct query to check streaming replication lag

On Fri, Jan 17, 2014 at 5:31 PM, Granthana Biswas wrote: > > > Thank you Sameer for your reply. Is there any other query that would help > get exact replication lag? > > You 2nd Query is the most accurate you can get. > 2. SELECT CASE WHEN pg_last_xlog_receive_location() = >>> pg_last_xlog_repl

Re: [GENERAL] Correct query to check streaming replication lag

Thank you Sameer for your reply. Is there any other query that would help get exact replication lag? Regards, Granthana Regards, Granthana On Fri, Jan 17, 2014 at 2:46 PM, Sameer Kumar wrote: > > On Tue, Jan 14, 2014 at 2:31 PM, Granthana Biswas wrote: > >> Can anyone please tell me which of t

Re: [GENERAL] Correct query to check streaming replication lag

Yes it's purely for monitoring purpose. Regards, Granthana On Fri, Jan 17, 2014 at 3:29 PM, Sameer Kumar wrote: > > > On Fri, Jan 17, 2014 at 5:31 PM, Granthana Biswas wrote: > >> >> >> Thank you Sameer for your reply. Is there any other query that would help >> get exact replication lag? >> >

Re: [GENERAL] Correct query to check streaming replication lag

On Jan 17, 2014, at 5:07 AM, Granthana Biswas wrote: > Yes it's purely for monitoring purpose. > I use the pg_controldata cmd locally and via bash/ssh shared keys and compare various values that seem interesting such as "Time of latest checkpoint, Latest checkpoint location." My interest i

[GENERAL] Question about plan difference between 9.3 and 9.3.2

Hi all, I had to move our production database to a new server with virtually identical hardware. At the same time I went to 9.3.2 from 9.3. Queries on the old server (nirvana) run many magnitudes faster than on the new server (dukkha). The two are configured the same except for the IP addre

Re: [GENERAL] Question about plan difference between 9.3 and 9.3.2

Jeff Ross writes: > I had to move our production database to a new server with virtually > identical hardware. At the same time I went to 9.3.2 from 9.3. > Queries on the old server (nirvana) run many magnitudes faster than on > the new server (dukkha). > The two are configured the same except

Re: [GENERAL] Question about plan difference between 9.3 and 9.3.2

On 1/17/14, 11:02 AM, Tom Lane wrote: Jeff Ross writes: I had to move our production database to a new server with virtually identical hardware. At the same time I went to 9.3.2 from 9.3. Queries on the old server (nirvana) run many magnitudes faster than on the new server (dukkha). The two ar

Re: [GENERAL] PostgreSQL with ZFS on Linux

On Fri, Jan 17, 2014 at 2:29 AM, Chris Travers wrote: > > > On Thu, Jan 16, 2014 at 11:14 PM, Sébastien Lorion < > s...@thestrangefactory.com> wrote: > >> On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer >> wrote: >> >>> Hi, >>> >>> > If you really want ZFS, I would highly recommend looking into

Re: [GENERAL] Any freeware graphic display of DDL software available?

O n Thu, 2014-01-16 at 08:45 -0800, Susan Cassidy wrote: > I > know about Erwin, but it is too expensive.T > hanks, > Susan > You can try ExecuteQuery from www.executequery.org. It is written in Java so needs the JDBC driver to access the database. It cannot read a DDL script but obtains meta d