On Mon, 3 Dec 2001, Manuel Trujillo wrote:
> SELECT d.gallery_id, e.subevent_id, d.result_type_id,
> d.result_type_name, e.language_id FROM ((SELECT b.gallery_id,
> b.element_id AS result_type_id, c.name AS result_type_name FROM
> gallery_element b, result_type c WHERE ((c.id = b.element_id) AND
I know someone already pointed out the cache differences between the
processors, and that is likely to contribute to the differences you have
observed.
As was stated in the message about cache, databases are extremely IO
bound. It is worth noting that Celeron's have a Front Side Bus speed of
66
On Monday, December 3, 2001, at 04:30 AM, Ludva Radomír (KM) wrote:
>
> Two machines:
> 1. Pentium3 400Mhz, hdd 8Gb, 64Mb RAM, kernel 2.2.14-5.0 (RedHat 6.2)
> 2. Celeron 400Mhz, hdd 8Gb, 64Mb RAM, kernel 2.2.14-5.0 (RedHat 6.2)
>
> The same database, the same postgres Version 7.1.3, the same
>
I have got the same problem.
I am working on it about a month :(.
It is not hot :-)
Two machines:
1. Pentium3 400Mhz, hdd 8Gb, 64Mb RAM, kernel 2.2.14-5.0 (RedHat 6.2)
2. Celeron 400Mhz, hdd 8Gb, 64Mb RAM, kernel 2.2.14-5.0 (RedHat 6.2)
The same database, the same postgres Version 7.1.3, the sa
On Mon, 3 Dec 2001, Manuel Trujillo wrote:
> I've serious problems with the speed of my database.
> If I execute any query like this;
>
> SELECT d.gallery_id, e.subevent_id, d.result_type_id,
> d.result_type_name, e.language_id FROM ((SELECT b.gallery_id,
> b.element_id AS result_type_id, c.name
>In old versions of PostgreSQL, we could see the database names in the
> pgsql/data/base directory, perhaps in this version, we can´t see the
> database names, we see numbers that represents the databases. I would
> like to know how can I do to appear the databases names instead of
> numbers.
e-
De : Len Morgan <[EMAIL PROTECTED]>
À : Can-Host Networks - Félix C.Courtemanche <[EMAIL PROTECTED]>;
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date : 14 mai, 2000 08:45
Objet : Re: [ADMIN] Problems with PostgreSQL
>I would check two things right away:
>
>1. Is the P
I would check two things right away:
1. Is the Postmaster running (ps ax | grep postmaster) and is it accepting
IP connections (i.e., not just UNIX socket connections)? This is shown by
the -i option you should see in the ps command. You did not mention the
version of Postgresql/RPM you are run
