On 11/02/2013 08:47 PM, Tom Lane wrote:
Author: Tom Lane
Branch: master Release: REL9_1_BR [3e5f9412d] 2010-10-06 19:31:05 -0400
Reduce the memory requirement for large ispell dictionaries.
I checked this patch:
http://www.postgresql.org/message-id/AANLkTi=4fUi1zoFMpZ==yf14rjdv_g1xgakvqmdy
On 11/02/2013 07:47 PM, John R Pierce wrote:
On 11/2/2013 11:03 AM, Grzegorz Tańczyk wrote:
Is there any way to limit total memory usage by postgres and keep
maximum connections limit? Postgresql.conf settings are default for
8.3.23. I need to have 100 connections in pool.
the size of
Hello,
Recently I had some problem with tsearch2 in postgres 8.3. Application
was using JDBC connection pool and it was possible that each connection
from the pool used tsearch2(with dictionary) in some query. This
resulted in almost every postmaster process using >0.5g memory.
Solution of thi
Hello,
Recently I had some problem with tsearch2 in postgres 8.3. Application
was using JDBC connection pool and it was possible that each connection
from the pool used tsearch2(with dictionary) in some query. This
resulted in almost every postmaster process using >0.5g memory.
Solution of thi
Hello,
Thanks for sharing your experiences with the problem.
W dniu 2013-10-09 00:47, "Gabriel E. Sánchez Martínez" pisze:
Partioning seems to be a good idea if a single table would be too big
to fit in your server's file cache, and also for management, since you
can drop partitions of old dat
Hello,
I have question regarding one of caveats from docs:
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html
"Partitioning using these techniques will work well with up to perhaps a
hundred partitions; don't try to use many thousands of partitions."
What's the alternative? Neste
"BEFORE INSERT" was the problem here, "AFTER INSERT" works fine
Thanks for all answers.
--
Regards,
Grzegorz
W dniu 2012-08-31 20:41, Grzegorz Tańczyk pisze:
Hello,
W dniu 2012-08-31 20:25, David Johnston pisze:
The question becomes how do you update the "item i
Hello,
W dniu 2012-08-31 20:25, David Johnston pisze:
The question becomes how do you update the "item id" on the "groups"
table when you add new records to "items".
I have a trigger on items table:
CREATE TRIGGER items_insert
BEFORE INSERT
ON items
FOR EACH ROW
EXECUTE PROCEDURE ite
Hello,
W dniu 2012-08-29 23:06, Merlin Moncure pisze:
Well, the only reason what you're trying to do works at all is because
the database isn't stricter about double checking to see if your stuff
is IMMUTABLE: it isn't, so of course it doesn't work. How about a
trigger on the child table that
Hello,
I have a problem with functional index feature in Postgres 8.3
There are two tables, lets call them: PARENTS and CHILDREN(with
timestamp column)
I created functional index on parents with function, which selects max
value of timestamp from child elements(for given parent_id).
The pr
Hello,
I have a problem with functional index feature in Postgres 8.3
There are two tables, lets call them: PARENTS and CHILDREN(with
timestamp column)
I created functional index on parents with function, which selects max
value of timestamp from child elements(for given parent_id).
The pr
Hello Martijn,
Wednesday, December 28, 2005, 1:17:54 PM, you wrote:
MvO> > My question is about the last line. Does those connections slow down
MvO> > database startup process? Now it looks like that they do, because
MvO> > when I shutdown backend then database starts immediatel, but I'm not
Hello,
Here is what I see in log file:
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the curre
nt transaction and exit, because another server process exited abnormally and po
ssibly corrupted s
13 matches
Mail list logo
