Hello List,
I am not sure that this is the appropriated list but I try...
I try to used BenchmarkSQL (release 2.3.2, built on February 12, 2006)
with PostgreSQL 8.2.2 and then 8.2.3.
By default, the JDBC driver included with this release of BenchmarkSQL
is "postgresql-8.0.309.jdbc3.jar".
So I d
-02-19 at 16:49 +0100, DANTE Alexandra wrote:
Where can I find the RPM compat-postgresql-libs-4-2 for RHEL4-AS and IA-64 ?
Those libs are extracted from 8.1.X RPMs and put together to form an RPM
package.
If you can build and send us 8.1.8 RPMs, I can build and upload that
compat RPM
Hello List,
I work with PostgreSQL 8.2.3 on a IA-64 server with Red Hat Enterprise
Linux 4 AS update 2 and I am looking for the RPM
compat-postgresql-libs-4-2 associated.
Unfortunately, I didn't find it on
http://www.postgresql.org/ftp/binary/, even in the RPM available for the
8.2.1 release
ing the "replace" function ?
Any suggestions ?
Regards,
Alexandra
A. Kretschmer wrote:
am Thu, dem 01.02.2007, um 15:58:08 +0100 mailte DANTE Alexandra folgendes:
Hello List,
Is it possible to import in a TIMESTAMP(6) field a timestamp in which
the format of hour is HH.MM
Hello List,
Is it possible to import in a TIMESTAMP(6) field a timestamp in which
the format of hour is HH.MM.SS (and not HH:MM:SS) ?
In the documentation, at
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-TIMEZONES,
I didn't find this format.
So can I think tha
Hello List,
Last question on the compilation of PostgreSQL 8.2 with the intel
compiler icc.
I work with an IA-64 server with Red Hat Enterprise Linux 4 AS update 2
on which the Intel compiler icc 9.1.045 is available and I build
PostgreSQL 8.2 with this compiler.
To do that I generated RPM fro
Hello Tom, Martijn and List,
Thank you for these precisions.
I checked the spec file used to build the RPM and compile PostgreSQL and
I ran the configure with the icc compiler by setting :
%configure CC=/opt/intel/cc/9.1.045/bin/icc CFLAGS='-O2 -pipe
-override_limits'
I was afraid that this I
Hello List,
I'm back with my questions on compilation of PostgreSQL 8.2. :-)
I work with an IA-64 server with Red Hat Enterprise Linux 4 AS update 2
on which the Intel compiler icc 9.1.045 is available.
I try to build PostgreSQL 8.2 with this compiler.
To do that :
- I generated RPM from the "
Hello List,
I am still trying to generate RPM for an IA-64 server with Red Hat
Enterprise Linux 4 AS and today, I got a question about the
"postgresql-8.2.0-2PGDG.src.rpm".
This src.rpm contains :
-rw-r--r-- 1 postgres postgres 12459207 Dec 2 20:25
postgresql-8.2.0.tar.bz2
-rw-r--r-- 1 po
Hello List,
I work on an IA-64 server with Red Hat Enterprise Linux 4 AS, and as the
8.2 release is now available, I try to generate RPM for IA-64.
To do that, I downloaded the "postgresql-8.2.0-2PGDG.src.rpm", extracted
the ".spec" file and these files :
-bash-3.00$ cd SOURCES/
-bash-3.00$ ls
rpm source available is : "rrdtool-1.2.13-1.fc3.rf.src.rpm".
Can I use it on RHEL4-AS ? I also tried to find the rpm sources on the
Red Hat web site, without success...
Thanks,
Alexandra
Robin Ericsson wrote:
On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote:
My problem is
Hello List,
I work with PostgreSQL 8.1.3 on an IA64 server with Red Hat Enterprise
Linux 4 AS and I try to install Munin 1.2.4.
To do that, I downloaded these RPM from Sourceforge :
- munin-1.2.4-8rhel4.noarch.rpm
-munin-node-1.2.4-8rhel4.noarch.rpm
and "munin-plugins-postgresql-0.3.tar.tar" fr
Hello Mont, hello List,
I am the person who wrote these threads and since, I haven't found the
solution to compile PostgreSQL on Windows 64 bits...Instead, I used a 32
bit release of PostgreSQL on Windows 64 bits.
I worked with "Microsoft Windows Server 2003, Enterprise Edition with
SP1 for It
Hello Tom, Martijn and List,
Thank you for yours answers !
This point is now closed for me and I can go further in the mecanisms of
VACUUM.
Regards,
Alexandra
Tom Lane wrote:
DANTE Alexandra <[EMAIL PROTECTED]> writes:
- during a SELECT query on a tuple just updated and co
s are done in the source code ?
Thank you very much !
Regards,
Alexandra DANTE
Martijn van Oosterhout wrote:
On Mon, Jul 31, 2006 at 11:04:58AM +0200, DANTE Alexandra wrote:
I've just seen that I've done a mistake in my example. My question was :
is it correct to think that the
Hello Martijn, hello List,
Thank you very much.
I still have some questions, further to your answers :
Martijn van Oosterhout wrote:
On Fri, Jul 28, 2006 at 12:00:19PM +0200, DANTE Alexandra wrote:
Hello List,
I try to understand perfectly the mecanisms used to update / delete a
tuple
Hello List,
I try to understand perfectly the mecanisms used to update / delete a
tuple (and consequently those used in VACUUM) and I've got some questions.
I've created a small database with only one table called "nation". This
table was created with this command :
CREATE TABLE nation(
Thank you Martijn for your answer !
I use the 8.1.3 release of PostgreSQL.
Will it be sensible to launch an ANALYZE after the VACUUM to update
statistics ?
Regards,
Alexandra
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
Imagine you have
Hello List,
Sorry to send an other e-mail on this subject but it is become a little
bit vague for me.
Imagine you have a database on which a lot of transactions are done
daily : the tables will contain a lot of dead tuples and the B-tree
index too.
If I do a VACUUM on this database, will the
s there a way to be more aggressive with pushing pages out to disk via
PostgreSQL ?
Regards,
Alexandra
Martijn van Oosterhout wrote:
On Mon, Jul 10, 2006 at 05:06:56PM +0200, DANTE Alexandra wrote:
Hello List,
I have uploaded charts on a ftp server.
You can access to these 6 graphs by doing
ftp vi
= 100
- bgwriter_all_maxpages = 1000
I hope someone will give me explanations on the background writer.
Thank you very much for your help.
Regards,
Alexandra DANTE
Martijn van Oosterhout wrote:
On Mon, Jul 10, 2006 at 02:56:48PM +0200, DANTE Alexandra wrote:
Hello List,
I’m using BenchmarkSQL to evaluate, characterize and optimize PostgreSQL
in transaction processing. I work with PostgreSQL 8.1.3 on RHEL4-AS,
Itanium-2 processor, 8GB RAM.
The database, generated via BenchmarkSQL and used, is a 200-warehouses
database and its size is about 20GB.
readed. Consequently, PostgreSQL can not
execute a query in several CPU, the source code of PostgreSQL is not
multi-threaded.
Is it correct ?
Thank you very much for your help.
Regards,
Alexandra
Martijn van Oosterhout wrote:
On Mon, Jul 10, 2006 at 11:47:06AM +0200, DANTE Alexandra wrote
Hello List,
I wonder if this compilation option is really taken into account as
PostgreSQL is not multi-threading but multi-processing.
I have read that without this option, the libpq won't know anything
about threads and may indeed have problems, but could you explain me how
this option runs
n Fri, 2006-07-07 at 01:57, DANTE Alexandra wrote:
Good morning List,
I have seen several posts on this concept but I don’t find a complete
response.
I’m using BenchmarkSQL to evaluate PostgreSQL in transaction processing
and I work with PostgreSQL 8.1.3 on RHEL4-AS, Itanium-2 processor, 8GB RAM.
Good morning List,
I have seen several posts on this concept but I don’t find a complete
response.
I’m using BenchmarkSQL to evaluate PostgreSQL in transaction processing
and I work with PostgreSQL 8.1.3 on RHEL4-AS, Itanium-2 processor, 8GB RAM.
The database, generated via BenchmarkSQL and u
Hello List,
After having compiled and installed PostGreSQL on IA64, Red Hat
Enterprise Linux 4 AS, I had to do the same thing on Windows 64 bits...
I have read that PostGreSQL wasn't test on Windows 64 bits, is it still
correct ?
My problem is to find how obtain an Unix/Linux environnement co
Martijn van Oosterhout a écrit :
On Mon, Mar 06, 2006 at 02:17:16PM +0100, DANTE ALEXANDRA wrote:
Hello,
We are working with PostGreSQL since november 2005, and ours questions
are automatically those of novice persons, that's why your answer
suprises us.
The aim of our question
Hello,
We are working with PostGreSQL since november 2005, and ours questions
are automatically those of novice persons, that's why your answer
suprises us.
The aim of our question about the "contrib" rpm was to understand why
this package exists, what it is used for, and how generate it. We
Hello,
We have a question concerning backup / restore of database.
Is it right if we say that for having a complete backup, we have do :
1. use pg_dumpall
2. do a backup of the modified "template1" database with pg_dump ?
Our question is how to save and restore a template database, as
"template
Hello,
We have generated a rpm with PostGreSQL 8.1.2, from the "tar.gz" file,
compiled with the "icc" Intel compiler on Red Hat Enterprise Linux 4 AS.
During the compilation, we have had few warnings, but nevertheless, we
work with this rpm without trouble.
We have a question about the contr
Hello,
We have a question about "pg_upgrade". We work with PostGreSQL 8.1.2.
We have seen that with the 8.1.0 release, some programs from contrib are
now included in PostGreSQL, such as "dbsize".
Is it the same thing with "pg_upgrade" ?
Does it still exist ? If not, is there another tool to re
e result file is about 16MB... I don't post it, but I can do an
archive of this file if you want...
I hope you would explain us with initdb fails.
Thank you for your help.
Regards,
Alexandra DANTE
Tom Lane a écrit :
DANTE ALEXANDRA <[EMAIL PROTECTED]> writes:
we recompil
Hello,
I work with Agnès Bocchino who have posted a message on the NOVICE
mailing-list on an initdb error.
Maybe we must post this message in the GENERAL mailing-list.
I try, hoping someone knows this error.
Regards,
Alexandra DANTE
Message original
Sujet: [NOVICE] Initdb p
Hello,
Is anyone working on an 8.1.0 RPM for IA64 on Red Hat Enterprise Linux 4
AS ?
On the web site :
http://www.postgresql.org/ftp/binary/v8.1.1/linux/rpms/redhat/, I have
found a "rhel-as 4" version for RHEL4 but I don't think it is a version
for IA64.
Could someone explain me how genera
Hello Tom,
I've got others questions on work-mem parameter.
On the "http://www.powerpostgresql.com/Downloads/annotated_conf_80.html";
web site, I've read that the work-mem specifies the amount of memory to
be used by internal sort operations ans hash tables before switching to
temporary disk f
Hello,
Just to give you explanation, I will try to explain you why I have set
the "work_mem" to 64MB.
I noticed that some of the queries have finished with an "out of memory"
because the file system on which temporary files were created was to
small. Consequently, I have increase the size of
answer in January.
Thank you.
Regards,
Alexandra DANTE
Seneca Cunningham a écrit :
DANTE ALEXANDRA wrote:
The person is charge of building PostGreSQL 8.1.0 has done a 32 bit
build and has used the "cc_r" compiler.
This person does not succeed to build PostGreSQL 8.1.0 with "g
writes:
On Tue, Dec 20, 2005 at 01:35:03PM +0100, DANTE ALEXANDRA wrote:
You will find below the explain plan of one of the queries which has
finished with "out of memory". This query contains aggregate and a
sub-select with 6 joins :
1. Firstly, it could be the Hash n
think I will try to optimize PostGreSQL in a second time by creating
appropriate indexes.
I don't think that this index is on relevent column for this query.
Regards,
Alexandra DANTE
Martijn van Oosterhout a écrit :
On Tue, Dec 20, 2005 at 01:35:03PM +0100, DANTE ALEXANDRA wrote:
You w
t;.l_partkey) AND (partsupp.ps_suppkey = "outer".l_s
uppkey))
-> Index Scan using i_o_orderkey on orders
(cost=0.00..5.19 rows=1 width=12)
Index Cond: (orders.o_orderkey =
"outer".l_orderkey)
-> Seq Scan on nation
bits to solve this error ?
Thank you for your help.
Regards,
Alexandra DANTE
Chris Browne a écrit :
[EMAIL PROTECTED] (DANTE ALEXANDRA) writes:
I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3,
with 300GB of datas.
Some of the queries launched on this database finish with
Hello,
I am a PostGreSQL newbie. I work with the 8.1.0 release on AIX 5.3, with
300GB of datas.
Some of the queries launched on this database finish with an "*out of
memory*". The queries which have failed contain a lot of join (between 6
tables), sub-select and aggregate. For these queries, t
launch
the VACUUM FULL ANALYZE to update the statistics.
Is it correct ? Why ANALYZE has taken less than one minute ?
Thanks for your help.
Regards
Alexandra DANTE
Tom Lane a écrit :
DANTE ALEXANDRA <[EMAIL PROTECTED]> writes:
Then, on each table, I have launched the "VACUUM FULL ANA
Hello,
This is my first posting in this mailing list and I am a PostGreSQL newbie.
I've posted this message in the "novice" mailing list last friday, but I
have any response.
I hope somenone could help me.
I realize a benchmarck on PostGreSQL on a 300Gb database. I used the
release 8.1.0.
I
45 matches
Mail list logo
