[GENERAL] apr-util-pgsql for CentOS 5.6 / 64 bit

Hello, does anybody know of a good source for a apr-util-pgsql rpm package for CentOS 5.6 / 64 bit and even more I'm curious, why isn't it included but the apr-util-mysql is included... Is apr-util-pgsql maybe part of some bigger package already? I'm using: # rpm -qa|grep post

[GENERAL] Service performance tuning.

Hi, Considering the fact that it is a critical service, what can be implemented to improve the postgreSQL service. Hailu

Re: [GENERAL] Service performance tuning.

On Sun, Jun 12, 2011 at 01:41:14PM +0300, abiy hailu wrote: Considering the fact that it is a critical service, what can be implemented to improve the postgreSQL service. take a look at these books and see which one fits your needs: http://www.postgresql.org/docs/books/ -- Sent via

Re: [GENERAL] Service performance tuning.

On 12/06/2011 13:36, Ray Stell wrote: On Sun, Jun 12, 2011 at 01:41:14PM +0300, abiy hailu wrote: Considering the fact that it is a critical service, what can be implemented to improve the postgreSQL service. take a look at these books and see which one fits your needs:

[GENERAL] Tweaking bytea / large object block sizes?

Hi. I'm a new Postgres user. If I happen to ask stupid questions please feel free to point me to any documentation I should read or guidelines for asking questions. I'm looking into storing binary data in Postgres and trying to understand how data is actually stored in the database. The dataset

Re: [GENERAL] FILLFACTOR and increasing index

Hi, 2011-05-12 00:28 keltezéssel, Tomas Vondra írta: Hi, I've studied the implementation of the btree indexes and how exactly the fillfactor is used, and in general - when a page split happens, the process needs to obtain more locks than with simple insert, which may result in contention

Re: [GENERAL] Tweaking bytea / large object block sizes?

Le dimanche 12 juin 2011 à 18:00 +0200, Hanno Schlichting a écrit : I'm looking into storing binary data in Postgres and trying to understand how data is actually stored in the database. The dataset I'm looking at is images, photos, pdf documents which should commonly be at a minimum 100kb,

[GENERAL] Out of tree build issue

I'm building on AIX 5.3 but I'm thinking this is on most (all?) platforms. I'm doing an out of tree build and got an error with: /usr/local/build/postgres-9.0.4/../../src/postgresql-9.0.4/src/backend/utils/cache/relcache.c:57:30: error: catalog/schemapg.h: No such file or directory I think the

Re: [GENERAL] FILLFACTOR and increasing index

Dne 12.6.2011 21:14, Boszormenyi Zoltan napsal(a): We recently had a testcase for exercising FILLFACTOR on indexes. Several (15+) GB raw data arrives daily and must be imported into the database for analytic purposes, the table is heavily partitioned and each partition has 5 or 6 indexes. The

Re: [GENERAL] Out of tree build issue

pedz pedz...@gmail.com writes: I'm building on AIX 5.3 but I'm thinking this is on most (all?) platforms. I'm doing an out of tree build and got an error with: /usr/local/build/postgres-9.0.4/../../src/postgresql-9.0.4/src/backend/utils/cache/relcache.c:57:30: error: catalog/schemapg.h: No

Re: [GENERAL] Tweaking bytea / large object block sizes?

On 6/12/11 12:00:19 PM, Hanno Schlichting wrote: Hi. I'm a new Postgres user. If I happen to ask stupid questions please feel free to point me to any documentation I should read or guidelines for asking questions. I'm looking into storing binary data in Postgres and trying to understand how

Re: [GENERAL] Out of tree build issue

Building from a tarball. I did: ../../src/postgresql-9.0.4/configure make Nothing weird. Let me know if I can help debug this. HTH pedz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Tweaking bytea / large object block sizes?

On 06/13/2011 12:00 AM, Hanno Schlichting wrote: But from what I read of Postgres, my best bet is to store data as large objects [2]. Going all the way down this means storing the binary data as 2kb chunks and adding table row overhead for each of those chunks. Using the bytea type and the

[GENERAL] Reinstalling

Hello, I have a database with which I was running Windows XP (version of PostgreSQL 8.3). After reinstalling the system on Windows 7 I'm having problems, even though you are installing on the same postgresql 8.3. Is it possible to connect to the old database to the new operating system and how

[GENERAL] Can't drop temp table in subfunction during cursor loop (being used by active queries)

Using PG 8.4.2 with Ubuntu 10.04.2 LTS. Inside a cursor of FUNCTION-A, I call another function (FUNCTION-B). Function-B has a Drop ,Table command followed by a CREATE TEMPORARY TABLE command. The cursor loops but when it runs out, it breaks, giving error: Cannot DROP TABLE tt_cms_alerts47

Re: [GENERAL] Tweaking bytea / large object block sizes?

On Sun, Jun 12, 2011 at 11:00 AM, Hanno Schlichting ha...@hannosch.eu wrote: Hi. I'm a new Postgres user. If I happen to ask stupid questions please feel free to point me to any documentation I should read or guidelines for asking questions. I'm looking into storing binary data in Postgres

Re: [GENERAL] Can't drop temp table in subfunction during cursor loop (being used by active queries)

jonathansfl wrote: Using PG 8.4.2 with Ubuntu 10.04.2 LTS. Inside a cursor of FUNCTION-A, I call another function (FUNCTION-B). Function-B has a Drop ,Table command followed by a CREATE TEMPORARY TABLE command. The cursor loops but when it runs out, it breaks, giving error: Cannot DROP