[PERFORM] Using more tha one index per table

Hi, I have a question concerning the uses of indexes in Postgresql. I red that in PG a query can not use more than one index per table: "a query or data manipulation command can use at most one index per table". Actually I found this a little weird and unfortunately I could not find further expl

[PERFORM] Queries with conditions using bitand operator

Hi, I have table "ARTICLE" containing a String a field "STATUS" that represents a number in binary format (for ex: 10011101). My application issues queries with where conditions that uses BITAND operator on this field (for ex: select * from article where status & 4 = 4). Thus i'm facing performa

[PERFORM] Fwd: Dead lock

. Is this a plausible explanation of what is going on? If yes, what can be done to avoid the dead lock? Thanks again. Original Message Subject:Dead lock Date: Mon, 14 Jun 2010 14:50:43 +0300 From: Elias Ghanem To: pgsql-performance@postgresql.org Hi all, I have

[PERFORM] Dead lock

Hi all, I have 2 data bases trying to perform an update query at the same time on a same table in a third data base using db link. I'm getting a dead lock exception: ERROR: deadlock detected DETAIL: Process 27305 waits for ShareLock on transaction 55575; blocked by process 27304. Process 2730

[PERFORM] Is DBLINK transactional

Hi, I am using dblink to read data from a remote data base, insert these data in the local database, update the red data in the remote database then continue to do some other work on the local database in the same transaction. My question is : Is db link transactional; If the local transaction fa

Re: [PERFORM] Multiple data base on same server

Ok thanks guys for your time -Original Message- From: Craig James [mailto:craig_ja...@emolecules.com] Sent: Friday, February 26, 2010 4:34 PM To: Richard Huxton Cc: elias ghanem; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Multiple data base on same server Richard Huxton

Re: [PERFORM] Multiple data base on same server

nt: Friday, February 26, 2010 1:44 PM To: elias ghanem Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Multiple data base on same server On 26/02/10 09:37, elias ghanem wrote: > Hi, > > I'm using postgresql 8.4 > > I need to install multiple postgresql dbs on one serv

[PERFORM] Multiple data base on same server

Hi, I'm using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same server? -Each DB needs 10 tablespaces, so if I create 10 different tablespaces for each DB I will

[PERFORM] Slow update query

Hi, For the explain analyze here's the output: "Seq Scan on in_sortie (cost=0.00..171140.19 rows=114449 width=84) (actual time=15.074..28461.349 rows=99611 loops=1)" " Output: type, site_id, fiche_produit_id, numero_commande, ligne_commande, date_sortie, quantite_sortie, date_livraison_souh

[PERFORM] Slow update query

Hi, Thanks for your help, here's more details as you requested: -The version of postgres is 8.4 (by the way select pg_version() is not working but let's concentrate on the query issue) Here's the full definition of the table with it's indices: -- Table: in_sortie -- DROP TABLE in_sortie;

[PERFORM] Slow update query

Hi, I'm not sure this is the right place to ask my question, so please if it is not let me know where I can get an answer from. I'm using postgresql 8.4 on Linux machine with 1.5 GB RAM, and I'm issuing an update query with a where clause that updates approximately 100 000 rows in a table contain