Re: [GENERAL] Streaming replication and sharding

2013-02-19 Thread René Romero Benavides
Looking forward to that release and best wishes for the project in general. On Tuesday, February 19, 2013 01:02:34 PM Michael Paquier wrote: On Tue, Feb 19, 2013 at 6:01 AM, René Romero Benavides wrote: There's also one project called Postgres-XC which seems very promising, but I'm kind of w

Re: [GENERAL] Connection with server dropping out

2013-02-19 Thread Adrian Klaver
On 02/19/2013 03:46 PM, Bastiaan Olij wrote: Hey Adrian, So where did you find this message listed in your original post: "On the client side we generally see a "could not receive data from server: The system cannot find the path specified."." Owh sorry, I'll explain a bit deeper. Omnis Stud

Re: [GENERAL] Connection with server dropping out

2013-02-19 Thread Bastiaan Olij
Hey Adrian, > > So where did you find this message listed in your original post: > > "On the client side we generally see a "could not receive data from > server: The system cannot find the path specified."." Owh sorry, I'll explain a bit deeper. Omnis Studio is a development environment that we u

Re: [GENERAL] Connection with server dropping out

2013-02-19 Thread Adrian Klaver
On 02/19/2013 12:28 PM, Bastiaan Olij wrote: Hey Adrian The part that has me a little confused is: "... The system cannot find the path specified." This looks more like a path issue than a connection issue. What is the client program ? What OS(es) is it running on? Is it just fetching data

Re: [GENERAL] Connection with server dropping out

2013-02-19 Thread Bastiaan Olij
Hey Adrian > > The part that has me a little confused is: > > "... The system cannot find the path specified." > > This looks more like a path issue than a connection issue. > > What is the client program ? > > What OS(es) is it running on? > > Is it just fetching data from the server or is it also

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Pavel Stehule
2013/2/19 Jeff Janes : > On Tue, Feb 19, 2013 at 4:38 AM, Pavel Stehule > wrote: >> 2013/2/19 patrick keshishian : >>> On Tuesday, February 19, 2013, Albe Laurenz wrote: One crude method would be to set statement_timeout to a nonzero value - then queries that take longer than

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Jeff Janes
On Tue, Feb 19, 2013 at 4:38 AM, Pavel Stehule wrote: > 2013/2/19 patrick keshishian : >> On Tuesday, February 19, 2013, Albe Laurenz wrote: >>> >>> >>> One crude method would be to set statement_timeout to a nonzero >>> value - then queries that take longer than that many seconds >>> will be canc

Re: [GENERAL] subselects vs WITH in views

2013-02-19 Thread Merlin Moncure
On Tue, Feb 19, 2013 at 9:22 AM, Joe Van Dyk wrote: > On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz > wrote: >> >> Joe Van Dyk wrote: >> > My assumption was that WITH acted just like subselects, but apparently >> > they don't? Using WITH doesn't >> > use the expected index. >> >> Currently WITH a

Re: [GENERAL] What happens if I create new threads from within a postgresql function?

2013-02-19 Thread Merlin Moncure
On Mon, Feb 18, 2013 at 1:59 PM, Seref Arikan wrote: > Hi Merlin, > My plan is exactly what you've suggested, sending bytea to an external > server. The networking library I'm using uses threads, and this is where I > am creating threads. Well, TBH, I find that odd. I know some network libraries

Re: [GENERAL] subselects vs WITH in views

2013-02-19 Thread Joe Van Dyk
On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz wrote: > Joe Van Dyk wrote: > > My assumption was that WITH acted just like subselects, but apparently > they don't? Using WITH doesn't > > use the expected index. > > Currently WITH acts as an "optimization fence", that means > that means that the pla

Re: [GENERAL] Questions: How to configure PostgreSQL at the beginning ....

2013-02-19 Thread Adrian Klaver
On 02/19/2013 03:07 AM, Tomas Pasterak wrote: Dear Sir or Madam, I have downloaded and installed the latest PostgreSQL version V9.2 to my Windows 7 OS PC. I want to have it running on my PC, as local host. Now I am facing some problems. 1.) I do not know, how to fill in the properties tab for

Re: [GENERAL] Questions: How to configure PostgreSQL at the beginning ....

2013-02-19 Thread Amit Kapila
On Tuesday, February 19, 2013 4:37 PM Tomas Pasterak wrote: > I have downloaded and installed the latest PostgreSQL version V9.2 to my Windows 7 OS PC. > I want to have it running on my PC, as local host. > Now I am facing some problems. > 1.) I do not know, how to fill in the properties tab for

Re: [GENERAL] Connection with server dropping out

2013-02-19 Thread Adrian Klaver
On 02/18/2013 10:37 PM, Bastiaan Olij wrote: Hi all, I'm hoping someone could help me with this issue, not sure if the general mailing list is the right place so apologies if this needs to be directed else where. We have several clients who are experiencing disconnects to our hosted postgres se

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Albe Laurenz
patrick keshishian wrote: >>> Any method to kill such query would it still hang out there? >> >> One crude method would be to set statement_timeout to a nonzero >> value - then queries that take longer than that many seconds >> will be canceled. > > you don't truly mean to advise that, do you? :)

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Pavel Stehule
2013/2/19 patrick keshishian : > On Tuesday, February 19, 2013, Albe Laurenz wrote: >> >> david harel wrote: >> > I use postgresql on a Linux server on a virtual machine (despite my >> > protest to IT personal). >> > The client is typically a web server implementing PHP sites. >> > >> > Customers m

Re: [GENERAL] Perl function leading to out of memory error

2013-02-19 Thread Tom Lane
Jan Strube writes: > we have a Java daemon that´s repeatedly calling a Perl function inside > our database (version 9.1.8). The function is called about 200 times per > second. While the Java program is running you can watch the memory usage > of the postmaster grow continuously until after a f

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread patrick keshishian
On Tuesday, February 19, 2013, Albe Laurenz wrote: > david harel wrote: > > I use postgresql on a Linux server on a virtual machine (despite my > protest to IT personal). > > The client is typically a web server implementing PHP sites. > > > > Customers many times close a page typically when a hea

[GENERAL] Questions: How to configure PostgreSQL at the beginning ....

2013-02-19 Thread Tomas Pasterak
Dear Sir or Madam, I have downloaded and installed the latest PostgreSQL version V9.2 to my Windows 7 OS PC. I want to have it running on my PC, as local host. Now I am facing some problems. 1.) I do not know, how to fill in the properties tab for the server, as name, host (what shall be host, s

Re: [GENERAL] Terminate query on page exit

2013-02-19 Thread Albe Laurenz
david harel wrote: > I use postgresql on a Linux server on a virtual machine (despite my protest > to IT personal). > The client is typically a web server implementing PHP sites. > > Customers many times close a page typically when a heavy report runs for too > long. > Using the command "top", I

[GENERAL] Perl function leading to out of memory error

2013-02-19 Thread Jan Strube
Hi, we have a Java daemon that´s repeatedly calling a Perl function inside our database (version 9.1.8). The function is called about 200 times per second. While the Java program is running you can watch the memory usage of the postmaster grow continuously until after a few hours we get an ou

[GENERAL] Terminate query on page exit

2013-02-19 Thread david harel
Greetings, I use postgresql on a Linux server on a virtual machine (despite my protest to IT personal). The client is typically a web server implementing PHP sites. Customers many times close a page typically when a heavy report runs for too long. Using the command "top", I got the impressio

Re: [GENERAL] subselects vs WITH in views

2013-02-19 Thread Albe Laurenz
Joe Van Dyk wrote: > My assumption was that WITH acted just like subselects, but apparently they > don't? Using WITH doesn't > use the expected index. Currently WITH acts as an "optimization fence", that means that means that the planner won't move conditions into or out of the WITH query. Yours