Re: [GENERAL] Postgres ODBC on Windows 10

On 01/26/2017 09:00 PM, Göran Hasse wrote: Hello! I tried the Postgres ODBC driver on Windows 10 but got a message "Arcitectural differens". Sorry for local langue in picture... Just a guess but it might be that you are using the 64bit driver with a 32bit application. See here for more

[GENERAL] Postgres ODBC on Windows 10

Hello! I tried the Postgres ODBC driver on Windows 10 but got a message "Arcitectural differens". Sorry for local langue in picture... Have amyone tried the ODBC driver in Windows 10? -- gor...@gmail.com Göran Hasse Boo 229 715 91 ODENSBACKEN Mob: 070-5530148 -- Sent via pgsql-general

Re: [GENERAL] recursive query too big to complete. are there any strategies to limit/partition?

On Jan 26, 2017, at 7:07 PM, David G. Johnston wrote: > ​Thinking aloud - why doesn't just finding every record with 5 descendants > not work? Any chain longer than 5 would have at least 5 items. Oh it works. This is why I ask these questions -- new perspectives! > ​Even without recursion

[GENERAL] recursive query too big to complete. are there any strategies to limit/partition?

There are over 20 million records in a self-referential database table, where one record may point to another record as a descendant. Because of a bug in application code, there was no limit on recursion. The max was supposed to be 4. A few outlier records have between 5 and 5000 descendants

Re: [GENERAL] Transaction apply speed on the standby

On Thu, Jan 26, 2017 at 8:34 AM, Rakesh Kumar wrote: > Ver 9.6.1 > > In a streaming replication can it be assumed that if both primary and > standby are of the same hardware, then the rate at which transactions are > applied on the standby will be same as that on

[GENERAL] Transaction apply speed on the standby

Ver 9.6.1 In a streaming replication can it be assumed that if both primary and standby are of the same hardware, then the rate at which transactions are applied on the standby will be same as that on primary. Or standbys are always slower than primary in applying transactions because of the

Re: [GENERAL] using hstore to store documents

On Thu, Jan 26, 2017 at 5:37 AM, Rita wrote: > of course, sorry for being vague. > > I have an external process generating a XML file (every 30 secs) which is > about 10MB. I would like to store the file as XML type for me to query > using xpath. I plan to query it every

Re: [GENERAL] using hstore to store documents

On 01/26/2017 04:37 AM, Rita wrote: of course, sorry for being vague. I have an external process generating a XML file (every 30 secs) which is about 10MB. I would like to store the file as XML type for me to query using xpath. I plan to query it every few seconds by few hundred clients. so, it

Re: [GENERAL] using hstore to store documents

On 01/26/2017 04:37 AM, Rita wrote: of course, sorry for being vague. I have an external process generating a XML file (every 30 secs) which is about 10MB. I would like to store the file as XML type for me to Does this mean you are using this:

Re: [GENERAL] using hstore to store documents

of course, sorry for being vague. I have an external process generating a XML file (every 30 secs) which is about 10MB. I would like to store the file as XML type for me to query using xpath. I plan to query it every few seconds by few hundred clients. so, it maybe easier for me create a separate

Re: [GENERAL] using hstore to store documents

On 01/26/2017 09:08 AM, Rita wrote: Is it possible to use hstore to store xml document? I would like to have "status" => "..."::xml Keys/values in hstore are simply text strings, so you can store anything you want formatted as a string. Not sure if that's what you're looking for though,

[GENERAL] using hstore to store documents

Is it possible to use hstore to store xml document? I would like to have "status" => "..."::xml -- --- Get your facts first, then you can distort them as you please.--