Hi Tom
Thanks to your hint.
The problem in my envirement is, that I don't use the standard perl, so the libperl.so
isn't in the default ld.so.conf directories.
After extending the envirement variable LD_LIBRARY_PATH the createlang command went
smooth.
Thanks
Philip
PS: Should have thought
Hi,
I have been using postgres for the last year now. The database has grown
from a mere few MBs to over 100GB data and expected to top up 300GB by the
end of the year. Lately performance of queries, inserts, updates has
continued to grow worse as the dataset has grown larger, even though most
Hi
I was reading through a lot of documentation including Admin guide and
INSTALL, but could not find this answer:
What directives do I have to configure when compiling Postgresql 7.1 (on
Solaris and Debian/Gnu Linux) to remove the 8k record size limit?
I have read that this limit can be remov
Currently we are using a PowerEdge 2400 server, 1 Gb RAM, dual-processor.
We have 5 x 36GB SCSI disks at RAID 5 for the database and one 36GB disk
for the WAL files, logging , os, etc.
Postgres configuration is set to
sort_mem = 65536
fsync = false
shared_buffers = 1000
The database consist of
Ave all Admins,
I searched the list for before this, but i didn't find an answer. I'm
doing all as the script (i think) and I don't get autentication to user. My
pg_hab.conf is (10.3.128.222 is the localhost):
localall password
Hi,
Anybody know how to create large objects in pl/pgsql program.I found
example for libpq in the postgresql documentation. But I could not
find any example for pl/pgsql.
I tried to use lo_create in pl/pgsql function. It did not work.
Thanks
---(end of broadcast)--
Robert -
You mention having a PostgreSQL database in production for around a year.
May I ask what version it is? I'm guessing you're still at 6.5.X,
in which case, I'd suggest an upgrade to 7.1.2, before doing anything
more drastic. Not only are there bug fixes, many improving stability
of the s
Marc Burgauer <[EMAIL PROTECTED]> writes:
> What directives do I have to configure when compiling Postgresql 7.1 (on
> Solaris and Debian/Gnu Linux) to remove the 8k record size limit?
You don't need to do anything. The block size isn't a constraint anymore.
regards, to
[EMAIL PROTECTED] writes:
> I have been using postgres for the last year now. The database has grown
> from a mere few MBs to over 100GB data and expected to top up 300GB by the
> end of the year. Lately performance of queries, inserts, updates has
> continued to grow worse as the dataset has gr
On Thursday 12 July 2001 13:06, you wrote:
> Using IBCS{Intel Binary Compatability System} is is supposed to be
> possible.
>
> I have never realy tried but it has been in the linux kernel for ever.
We have run the SCO versions of Oracle 7.x, 8.x and 8i using the IBCS on
x86 RedHat 5.x and 6.x.
I'm using the latest version 7.1.2 (athough I started with 7 and then
migrated to 7.1).
Problem is that we have few main tables which continue to grow as against
having a large number of tables. As I see it, the more data you have in a
table, the longer the query will take proportionally (even
Since I have a number of heavy inserts per day, dropping the indexes and
recreating them could be an option. Only problem I see is that to
recreate them they take alot of time, at which queries will be tremendously
slow.
regarsd
Robert
12 matches
Mail list logo
