Hi,
i am using postgresql version 8.0.1 on Gentoo Linux and from time to time a
postgres process that is marked as idle - "postgres: user db IP(34079) idle"
- starts using 100% CPU. There is nothing in the logs, so i don't have a clue
what could be the problem.
Regards,
Jernej
). Is that of any help ?
Regards,
Jernej Kos.
On Thursday 09 of June 2005 17:19, you wrote:
> Jernej Kos <[EMAIL PROTECTED]> writes:
> > i am using postgresql version 8.0.1 on Gentoo Linux and from time to time
> > a postgres process that is marked as idle - "postg
Well I can't get any better backtraces (even with --enable-debug). The strange
thing is that this just happens once in a while and the process doesn't stop
until it is killed (or postgre is restarted). Any suggestions ?
Regards,
Jernej Kos.
On Sunday 12 of June 2005 18:01, you wrote
I have a query which orders data like this: ORDER BY a.col1, b.col2 where a
and b are different tables. Both tables are really big and so, ordering takes
quite a while. Now i would like to create an index to speed things up, but i
don't know how to create such an index that would cover both colu
Yes i tried that already - and as you said, it works. But i need to have one
column sorted DESC and one ASC. Is there any way this could be done ?
Regards,
Jernej Kos.
On Wednesday 16 of June 2004 08:12, Martijn van Oosterhout wrote:
> On Wed, Jun 16, 2004 at 07:12:26AM +0200, Jernej Kos wr
