Please don't top post.
paulo matadr wrote:
My aplication return erro:
2009-01-20 10:22:03,264 INFO [STDOUT] Caused by: org.postgresql.util.
PSQLException: ERROR: invalid memory alloc request size 1705447581
What are you doing in terms of SQL?
INSERT, UPDATE, DELETE?
How big are the
Hello,
I've a question regarding caching of results in the PostgreSQL-Server.
As expected a:
SELECT COUNT(*) FROM table;
causes a sequential scan of the table. The table I tested this on has about 345
000 tuples. This and any following run took about 50-60 seconds on a test
system
I think identified the problem
lts's check log below:
Query:
SELECTSTATEMENT: select relatorios0_.fuin_id as fuin5_1_, relatorios0_.rege_id
as rege1_1_, relatorios0_.rege_id as r
ege1_624_0_,
relatorios0_.rege_tmultimaalteracao as rege2_624_0_,
relatorios0_.rege_nnpaginas
as rege3_624_0_,
checkpoints don't have anything to do with it.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi All,
I would like to ask your help in understanding vacuum activities.
I have a heavily-updated table with this structure:
colA bigint not null
colB character varying(128) not null
colC character varying(200) not null
colD character varying(200) not null
colE character varying(20)
Indexes:
We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to the
8.3.x version.
From the postgres web site, I can see the 8.3.5 is the latest version.
Question for people who have been on 8.3.5:
Is 8.3.5 very safe to use (no major new bugs)? Is it really better than the
older
On Jan 22, 2009, at 9:50 AM, Jessica Richard wrote:
We are going to upgrade our Postgres servers (most 8.2.9 and some
8.2.4) to the 8.3.x version.
From the postgres web site, I can see the 8.3.5 is the latest version.
Question for people who have been on 8.3.5:
Is 8.3.5 very safe to use
I'm still having problems with ssl. My ssl_ciphers line in
postgresql.conf looks as the following:
ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
When I try to connect to the database from another system I get this
error...
walt...@cat:~$ psql -p 5433 -U walterc -d walterc -h db
psql: SSL SYSCALL
Please don't top post.
paulo matadr wrote:
I think identified the problem
lts's check log below:
Query:
SELECTSTATEMENT: select relatorios0_.fuin_id as fuin5_1_,
relatorios0_.rege_id as rege1_1_, relatorios0_.rege_id as r
ege1_624_0_, relatorios0_.rege_tmultimaalteracao as rege2_624_0_,
Hi,
I'm trying to install pgbouncer on Linux 64 bits server, and getting a
error about :conftest.c:8:28: error: ac_nonexistent.h: No such file or
directory.
See bellow all info ,any tips what's missing , i have installed the last
libevent patch:
./configure --prefix=/usr/local
On Wed, Jan 21, 2009 at 8:32 PM, Cédric Villemain
cedric.villem...@dalibo.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Vladimir Rusinov a écrit :
On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater jsaba...@gmail.com
wrote:
And I am in the process of writing a bunch of scripts
configure:2629: checking how to run the C preprocessor
configure:2669: gcc -E conftest.c
configure:2675: $? = 0
configure:2706: gcc -E conftest.c
conftest.c:8:28: error: ac_nonexistent.h: No such file or
directory
configure:2712: $? = 1
configure: failed program was:
| /* confdefs.h.
On Thu, Jan 22, 2009 at 10:35:22AM -0500, Carol Walter wrote:
I'm still having problems with ssl. My ssl_ciphers line in postgresql.conf
looks as the following:
ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
this parameter was not available in 8.2.x when I tested so what
I say here has little basis.
On Wed, Jan 21, 2009 at 8:30 PM, Jaume Sabater jsaba...@gmail.com wrote:
On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
vladi...@greenmice.info wrote:
And I am in the process of writing a bunch of scripts that the Zabbix
agent will execute to feed the server with information, so that
Larry Rosenman wrote:
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Jessica Richard
Sent: Thursday, January 22, 2009 8:51 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres 8.3.x upgrade
FYI, we should point people here to explain
On Thu, Jan 22, 2009 at 7:50 AM, Jessica Richard rjes...@yahoo.com wrote:
We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to
the 8.3.x version.
From the postgres web site, I can see the 8.3.5 is the latest version.
Question for people who have been on 8.3.5:
Is
jan-peter.seif...@gmx.de wrote:
Hello,
I've a question regarding caching of results in the PostgreSQL-Server.
If you restart the server it will clear out the shared buffer pool, and
subsequent queries would show the appropriate delay.. You can clear out
the OS disk cache (on linux) using
17 matches
Mail list logo