I have recently seen my 'postmaster' processes sucking up a lot of CPU.
What can I do to determine why they have started eating the processors?
I am running 7.4.2 on Red Hat Enterprise 2.1.
Thanks,
Hunter
---(end of broadcast)---
TIP 8: explain
Hello,
Varchar by default will truncate extra space at the end. If the table
column is defined as char or you cast the varchar to a char data type it
will have a fixed size of 40 characters.
Mike
On Tue, 2004-07-13 at 06:29, Constantin Khatsckevich wrote:
> Hello!
>
> Can I get ordered length
Have you run the analyze function on the table or database?
We would need to see the sql for your tests to determine why it was or
was not used.
By the way the pgsql-performance list is probably a much better place to
discuss this.
Mike
On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> I re
I can't help you with that error. Have you searched the pgsql-hacker
mailing list? It is much more appropriate for this question.
On Tue, 2004-07-13 at 03:52, Charles Su wrote:
> Hi , Dear Postgresql Creator, I live in Taiwan and try to run
> postgres_win32_7.5_devel but when I do initdb -L "c
It seems that postgresql crashed recently, tried to restart
automatically, and has not succesfully restarted.
You will need to stop the postmaster daemon manually, probably delete
the postmaster.pid file, and restart the postmaster daemon.
Chances are that anyone trying to query the database is n
Well there is no native windows version yet.
You can use cygwin from www.cygwin.com to run postgres under a unix
emulator.
It has ssl compiled with it by default. I forget if openssl needs to be
present on the machine as well.
On Mon, 2004-07-12 at 16:08, Otto Blomqvist wrote:
> Hello !
>
Well there is no native windows version yet.
You can use cygwin from www.cygwin.com to run postgres under a unix
emulator.
On Sat, 2004-07-10 at 08:02, Praveen wrote:
> Hi All,
>
> Can anybody tell from where i can download the latest Postgress Windows version?
>
> Thanks,
> Praveen
>
> -
What do you want to change it to?
Another number? Use something like Update table set field = field + 1
I assume you are going to store the result in the same table column?
On Mon, 2004-07-12 at 13:07, [EMAIL PROTECTED] wrote:
> I have a int4 coloumn, and I want to change the last bit the the
That depends on the platform you are installing it. The tar file should
contain a file named INSTALL which lists the instructions on how to
install by platform.
Mike
On Sun, 2004-07-11 at 00:01, network lines wrote:
> OK, i went to their web site and downloaded some
> *.tar files...which one do
Hi,
I think you will need to be more specific to what scripting language you
are attempting to use, which blob data type is being used in the db(lo
or bytea), and possibly the database driver used (odbc / .net)
to get a response from the community.
Mike
On Fri, 2004-07-16 at 08:21, Dylan Milks wr
On Jul 12, 2004, at 9:53 AM, Benjamin Smith wrote:
I'm writing an intranet app in PHP, and having issues around
constraints.
Specifically, the error messages coming back from PG aren't very user
friendly. I'm looking for a way to make this a bit more smooth to the
end
user, and ensure that my con
Hi all,
Errors running a psql batch that has worked for weeks without a
problem:
$ uname -a
Linux s1 2.6.6-1.435.2.3 #1 Thu Jul 1 08:25:29 EDT 2004 i686 athlon
i386 GNU/Linux
$ rpm -q postgresql
postgresql-7.4.2-1
$ psql KakaoStats
Bem-vindo ao psql 7.4.2, o terminal iterativo do PostgreSQL.
sel
12 matches
Mail list logo
