Oleg Bartunov wrote:
On Tue, 27 Jun 2006, Hannes Dorbath wrote:
http://www.symfony-project.com/askeet/21
How does this dead simple approach compare to TSearch performance /
scaling wise?
Sorry, I was a bit off-topic. Lucene scales as any inverted index based
engine. In 8.2 tsearch2 also has
My experience has been that RAID5 + Postgres = counter productive. I've
been happier with a 4-way software mirror (Linux).
In the past, Postgres has been very drive seek intensive, because of the
way index scans were performed. RAID5 does *NOTHING* to help this. Raw
disk throughput is essen
I'm running 8.0.8 on a raid 5 over 13 disks, and select performance on a
query that needs to join two large tables is very bad. top shows pg
using 2 to 4 percent cpu. Doing a query on one big table uses 30 to 45
percent cpu.
This is RHEL 4 running kernel 2.6.9-22.ELsmp, using an LSI fiber ch
"Parang Saraf" <[EMAIL PROTECTED]> writes:
> I wanted to know about graph plotting engine that is compatible with
> postgres 8.1.4. I am performing some queries like :
> Comparing the speed of three runners namely A, B and C versus time. I want
> to publish the result in a graphical manner on the
> I wanted to know about graph plotting engine that is compatible with
> postgres 8.1.4. I am performing some queries like :
> Comparing the speed of three runners namely A, B and C versus time. I want
> to publish the result in a graphical manner on the net instead of just
> providing the data.
>
hey,I wanted to know about graph plotting engine that is compatible with postgres 8.1.4. I am performing some queries like :Comparing the speed of three runners namely A, B and C versus time. I want to publish the result in a graphical manner on the net instead of just providing the data.
So, if y
On Mon, Jun 26, 2006 at 04:03:11PM +0200, Francesco Formenti - TVBLOB S.r.l.
wrote:
> Tom Lane wrote:
>
> >"Francesco Formenti - TVBLOB S.r.l." <[EMAIL PROTECTED]>
> >writes:
> >
> >>we are developing a system for profile management. The simplified schema
> >>is composed by three tables:
You n
On Tuesday 27 June 2006 11:10, Karl O. Pinc wrote:
> On 06/27/2006 09:29:36 AM, Nikolay Samokhvalov wrote:
> > So, what about it?
> >
> > I periodically encounter with the same problem. People (e.g. me :-)
> > but not only) expect that when they use pg_dump to backup some
> > database (either sche
Tom Lane wrote:
The reason I didn't patch it myself is that I'm not quite clear on what
*should* be happening here. What effect should a large delete have on
the ANALYZE threshold, exactly? You could argue that a deletion
potentially changes the statistics (by omission), and therefore inserts,
Hi,
On Tue, 2006-06-27 at 20:49 +0530, surabhi.ahuja wrote:
> it is ok if i uninstall the current version of postgres 8.0.0
No. Please read this before you proceed:
http://pgfoundry.org/docman/?group_id=148
> i am trying to install the rpms for 8.1.4 FC(4) Where can i find the
> instaruc
On Tue, Jun 27, 2006 at 13:43:21 +0200,
Christian Rengstl <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> i am in the middle of breaking my head over designing a database and came to
> the following question/problem: i have persons whose values (integer) have to
> be entered in the db, but per perso
On Tue, Jun 27, 2006 at 20:49:46 +0530,
"surabhi.ahuja" <[EMAIL PROTECTED]> wrote:
> it is ok if i uninstall the current version of postgres 8.0.0
You need to dump you database(s) first unless you are upgrading to something
in the 8.0.x series.
---(end of broadcast)-
> it is ok if i uninstall the current version of postgres 8.0.0
> which i have done.
Well before you do any un-installing you should read and understand:
http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html
Regards,
Richard Broersma Jr.
---(end of broad
On Tue, 27 Jun 2006, Hannes Dorbath wrote:
On 27.06.2006 13:31, Oleg Bartunov wrote:
On Tue, 27 Jun 2006, Hannes Dorbath wrote:
http://www.symfony-project.com/askeet/21
How does this dead simple approach compare to TSearch performance /
scaling wise?
You miss the main point in tsearch2 -
On Tue, Jun 27, 2006 at 00:52:48 -0300,
Bruno Almeida do Lago <[EMAIL PROTECTED]> wrote:
>
> Oracle 8.1.7 used to have a severe lock contention when FKs had no index
> (causing an sx table lock). AFAIK this was "fixed" on 9i with the addition
> of "shared row locking".
In Postgres this problem
Hi Tom, Alvaro,Thanks for your work on this. Please keep me posted as to which version in CVS this fix will be applied to and I will do my best to test it.Thanks again! --Dylan HansenEnterprise Systems DeveloperOn 27-Jun-06, at 5:42 AM, Alvaro Herrera wrote:Tom Lane wrote: Alvaro Herrera <[EMAIL P
On Tue, 2006-06-27 at 08:05, [EMAIL PROTECTED] wrote:
> I have here HP DL 380 G3 und HP DL 380 G4. (here Smart Array 5i and Smart
> Array 6i)
> Maybe there are problems with old linux kernel (but as far as i know >
> 2.4.27)
> I dont know about such performance problems, maybe the conrollers are fa
James,
the "psql" command as you know is just the command line program that
requests connection to a database and depending how you issue the
command, determines if it's attempting to connect to a local file, or
via a network protocol (commonly TCP/IP). When you issue the command
from a remot
On 06/27/2006 09:29:36 AM, Nikolay Samokhvalov wrote:
So, what about it?
I periodically encounter with the same problem. People (e.g. me :-)
but not only) expect that when they use pg_dump to backup some
database (either schema only or both schema and data), all database
properties will be dum
Title: Re: [GENERAL] planning to upgrade to 8.1
it is ok if i uninstall the
current version of postgres 8.0.0
which i have done.
i am trying to install the rpms for 8.1.4
FC(4)
Where can i find the instaructions to
download the rpms.
what i did was as follows,
1. instal the rpm
po
On 27.06.2006 13:31, Oleg Bartunov wrote:
On Tue, 27 Jun 2006, Hannes Dorbath wrote:
http://www.symfony-project.com/askeet/21
How does this dead simple approach compare to TSearch performance /
scaling wise?
You miss the main point in tsearch2 - full integration with database, i.e.,
full ac
So, what about it?
I periodically encounter with the same problem. People (e.g. me :-)
but not only) expect that when they use pg_dump to backup some
database (either schema only or both schema and data), all database
properties will be dumped and, then, restored.
People think that this thing s
On Jun 27, 2006, at 1:35 AM, chent wrote:
I want to know who developed the libpq. Can anybody help me?How about
the license of the libpq?Thank you!
libpq was developed by the PostgreSQL Global Development Group. The
license of libpq is the same as PostgreSQL: BSD. See the FAQ:
http://www
> I am currently using 8.0.0, i heard that 8.1 can help in performance boost
> especially if the
> system is multi core processor.
> i am also planning to upgrade.
> To which version should i upgrade?
> Also Please tell if ther will be a need to build my programs again.
> I mean is it ok if i us
On Mon, Jun 26, 2006 at 01:51:24PM -0700, James wrote:
> In this command
> psql -h host ...
>
> does it look for pg_hba.conf in the client or in the server?
The server. Client machines do not necessarily have a pg_hba.conf and
even if they do, clients are unlikely to be able to read it.
Have a n
Hi,I have some little issue with restricting right for a profile.i've created a profile "kmt_admin" that should have only access to "kmt" database.this profile should be able to create table, functions, but it should not have access to other databases or to create additional profiles...
i setu
ok i have understand
many thanks to all!
On 6/27/06, Erik Jones <[EMAIL PROTECTED]> wrote:
nik600 wrote:
> hi
>
> i don't have understand how works inheritance of tables...
>
> if table B inherits from table A
>
> - A and B must share primary keys?
>
> - if i isert record in B the record is rep
In this command
psql -h host ...
does it look for pg_hba.conf in the client or in the server?
James
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Can Druid reverse engineer an Access 97 MDB file, say, through an OBDC
connection? I would like to replicate the schema from an Access 97
database, then be able to forward engineer to PostgreSQL and other
databases.
If Druid can't reverse engineer, can another open source tool do the
job?
Thanks
subscribe
I want to know who developed the libpq. Can anybody help me?How about
the license of the libpq?Thank you!
end
--
以上です、よろしくお願いします。
---
(Mr.)Chen Tao
OLFDB, 2nd R&D Department
NEC Advanced Software Technology(Beijing)Co.,Ltd
I have here HP DL 380 G3 und HP DL 380 G4. (here Smart Array 5i and Smart
Array 6i)
Maybe there are problems with old linux kernel (but as far as i know >
2.4.27)
I dont know about such performance problems, maybe the conrollers are faster
under windows.
The battery backup write cache are very im
"Christian Rengstl" <[EMAIL PROTECTED]> writes:
> i am in the middle of breaking my head over designing a database and came to
> the following question/problem: i have persons whose values (integer) have to
> be entered in the db, but per person the amount of values ranges from 10 to
> around 50.
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > + /* last_anl_tuples must never exceed n_live_tuples */
>
> If we actually believe the above statement, it seems like your patch
> to pgstat_recv_tabstat() opens a new issue: with that patch, it is
> possible for pgstat_rec
Title: [GENERAL] Preformace boost -- by 8.0.4 upgrade to 8.1.4
I am currently using 8.0.0, i
heard that 8.1 can help in performance boost especially if the system is multi
core processor.
i am also planning to
upgrade.
To which version should i
upgrade?
Also Please tell if ther will be a
Hi list,
i am in the middle of breaking my head over designing a database and came to
the following question/problem: i have persons whose values (integer) have to
be entered in the db, but per person the amount of values ranges from 10 to
around 50. Now my question is if it makes sense, conce
On Tue, 27 Jun 2006, Hannes Dorbath wrote:
http://www.symfony-project.com/askeet/21
How does this dead simple approach compare to TSearch performance / scaling
wise?
You miss the main point in tsearch2 - full integration with database, i.e.,
full access to metadata, ACID.
Lucene has no
I wonder if it would be possible/feasable to have anonymous PL functions
in PostgreSQL? I'm thinking of something along the lines of:
EXECUTE $
DECLARE
tableName text;
BEGIN;
FOR tableName
IN SELECT table_name
FROM information_schema.tables
WHERE t
http://www.symfony-project.com/askeet/21
How does this dead simple approach compare to TSearch performance /
scaling wise?
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Title: Nachricht
I have
here an Smart Array 6i with 192 MB Battery Backup Write Cache with several 146
MB U320 SCSI HDs
and I
get read/write speed till 120 MB per secound (HP ProLiant DL 380G4) under Debian
Linux with
Kernel
2.4.32 an Postgresql 7.4.13.
Greetings,
-Franz
-Ursp
39 matches
Mail list logo
