Re: [GENERAL] select now() problem?

2010-09-03 Thread Grzegorz Jaƛkiewicz
I wonder if there's an equivalent of gcore on windows. If there is, it might be useful. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] select now() problem?

2010-09-02 Thread Eduardo Piombino
Hello list, I'm having a problem with a production system. I have an application that runs 7x24. It is multithreaded, and every thread has its own connection to the database. We have two types of devices connected to each thread, human operated PCs for billing purposes, and rabbit microcontrollers

Re: [GENERAL] select now() problem?

2010-09-02 Thread Tom Lane
Eduardo Piombino drak...@gmail.com writes: Do you have any idea on what could be causing a SELECT NOW() to never come back? That's truly bizarre. Can you attach to one of these stuck processes with a debugger and get a stack trace? regards, tom lane -- Sent via

Re: [GENERAL] select now() problem?

2010-09-02 Thread Eduardo Piombino
The only difference from the database point of view, is that PCs transactions, since they are much more complex, usually start with a ROLLBACK (arguable, it will be eventually removed) and for devices they usually just start with a COMMIT. Correction ... and for devices they usually just start