[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 compat-postgresql-

[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 pgsql-gen

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: http://www.postgresql.o

[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 I

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 cont

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. T

Re: [GENERAL] Out of tree build issue

pedz 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 such file or di

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 dat

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: http://www.postgresql.org/mailpref/pgsql-general

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 toast

[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 t

[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 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

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 T

[GENERAL] psql core dump

Hi Guys, I downloaded a 9.0.4 binary from EnterpriseDB: http://www.enterprisedb.com/postgresql-904-installers-linux64 After several tires, it seems the psql client is very easy to core dump. See attached the core dump information. Is it a known psql issue? or it just related to EnterpriseDB pack