Re: [GENERAL] Data Guard for Postgres?

2013-12-13 Thread AI Rumman
Postgresql 9.2 streaming replication which is very much similar with Oracle Data Guard. On Fri, Dec 13, 2013 at 1:57 PM, Roy Anderson wrote: > Good day. I am inquiring as to whether there is a free solution > available that approximates, in Postgres, what Data Guard does for > Oracle DB. Can any

Re: [GENERAL] out of memory issue

2013-12-13 Thread Jamin Shanti
I wanted to answer this for you but I didn't see a reply button on the site. In pgadmin, it's File ==> Options ==> Query tool ==> History file ==> default is 1024. try 4096 if you have more then 8G on your PC.

[GENERAL] Data Guard for Postgres?

2013-12-13 Thread Roy Anderson
Good day. I am inquiring as to whether there is a free solution available that approximates, in Postgres, what Data Guard does for Oracle DB. Can anyone advise? Thank you, Roy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

[GENERAL] Unexpected update behaviour

2013-12-13 Thread Victor Yegorov
Greetings. I've hit a strange issue. This is a simplified setup. First, run create.sql to get a couple of tables. Then, run the update query. Tested on 9.2.6 and 9.3.2. Now: - if I remove the UNION ALL part of the inner query, UPDATE works; - if I move the `raw` subquery into the CTE, UPDATE wor

Re: [GENERAL] Grouping, Aggregate, Min, Max

2013-12-13 Thread Kevin Grittner
Misa Simic wrote: > So I wonder - is there some kind of aggregate window function > what does desired results? Not built in, but PostgreSQL makes it pretty easy to do so.  With a little effort to define your own aggregate function, your query can look like this: SELECT     thing_id,     categor

Re: [GENERAL] design for multiple time series

2013-12-13 Thread salah jubeh
>On 12/13/2013 4:46 AM, rob stone wrote: >> The only fly in the ointment with this is a rain gauge. If you don't >> empty it each day the actual rainfall is the difference between >> readings. >(somewhat off topic) >The electronic rain gauges I've seen have all been tip-bucket. they >measure eac

Re: [GENERAL] design for multiple time series

2013-12-13 Thread John R Pierce
On 12/13/2013 4:46 AM, rob stone wrote: The only fly in the ointment with this is a rain gauge. If you don't empty it each day the actual rainfall is the difference between readings. (somewhat off topic) The electronic rain gauges I've seen have all been tip-bucket. they measure each 0.01" (o

Re: [GENERAL] Grouping, Aggregate, Min, Max

2013-12-13 Thread David Johnston
Re:custom aggregate: I'd probably try building a two dimensional array in the state transition function. Take the new value and check if it is adjacent to the last value in the last bin of the current state. If so add it to that bin. If not create a new bin and store it there. Requires sorted i

Re: [GENERAL] invisible dependencies on a table?

2013-12-13 Thread Adrian Klaver
On 12/12/2013 08:24 PM, Tim Uckun wrote: I have a table foo. It has a serial column called "id". I execute the following statement ALTER TABLE table_name RENAME TO archived_table_name; CREATE TABLE table_name (LIKE archived_table_name INCLUDING DEFAULTS INCLUDING CONSTRAINTS I

Re: [GENERAL] While only running pg_dump, postgresql performs writes inside base/ directory. How can we stop this?

2013-12-13 Thread Spiros Ioannou
- autovacuum is not off in the pre-snapshot (production) database. It auto-runs every 2 weeks to avoid transaction ID wraparound. - I tried modifying pgdump to have a more relaxed transaction isolation (READ UNCOMMITTED) instead of the default (serializable) but this didn't help. thanks for the inf

Re: [GENERAL] design for multiple time series

2013-12-13 Thread rob stone
O n Thu, 2013-12-12 at 12:45 -0600, Seb wrote:I 'm working on the design of a database for time series data collected -- Et in Arcadia, ego. Floripa -- city of Land Rovers and alligators swimming in creeks. > sampling scheme, but not all. I initially thought it would be a good > idea to have a

Re: [GENERAL] Grouping, Aggregate, Min, Max

2013-12-13 Thread Misa Simic
Thanks Rémi-C, Well, not sure is it a goal to avoid aggregates... Bellow problem/solution even works (not sure) I guess would produce (if we imagine instead of count it use min and max in a row, though this case a bit complicated because of it should take real values from the source table, becaus

Re: [GENERAL] Grouping, Aggregate, Min, Max

2013-12-13 Thread Rémi Cura
There is a trick to simplify the thing and avoid using aggregates : I think it will give you your answer. http://postgresql.1045698.n5.nabble.com/Count-of-records-in-a-row-td5775363i20.html Cheers, Rémi-C 2013/12/13 Misa Simic > Hi All, > > I am not sure how to define with words what I want t

[GENERAL] Grouping, Aggregate, Min, Max

2013-12-13 Thread Misa Simic
Hi All, I am not sure how to define with words what I want to accomplish (so can't ask google the right question :) ) So will try to explain with sample data and expected result: Scenario 1) id thing_id category period_id 1 1 A 1 2 1 A 2 3 1 A 3 4 1 A 4 5 1 A 5 6 1 A 6 7 1 A 7 8 1 A 8

Re: [GENERAL] design for multiple time series

2013-12-13 Thread Jayadevan M
On Fri, Dec 13, 2013 at 12:15 AM, Seb wrote: > Hi, > > I'm working on the design of a database for time series data collected > by a variety of meteorological sensors. Many sensors share the same > sampling scheme, but not all. I initially thought it would be a good > idea to have a table ident