Re: [PERFORM] pgpoolAdmin handling several pgpool-II clusters

2011-05-02 Thread Jorgen
>No. pgpoolAdmin only supports one pgpool-II server. We have installed pgpoolAdmin, and it is a good and easy to use web app. So we now have to choose between 3 x pgpoolAdmin or go for PostgresXC. Jørgen Münster-Swendsen www.kms.dk -- View this message in context: http://postgresql.1045698.n5.

Re: [PERFORM] Query improvement

2011-05-02 Thread Mark
Here is EXPLAIN ANALYZE: "Limit (cost=136568.00..136568.25 rows=100 width=185) (actual time=1952.174..1952.215 rows=100 loops=1)" " -> Sort (cost=136568.00..137152.26 rows=233703 width=185) (actual time=1952.172..1952.188 rows=100 loops=1)" "Sort Key: ((ts_rank(pc.textvector, to_tsquer

Re: [PERFORM] 8.4.7, incorrect estimate

2011-05-02 Thread Wayne Conrad
On 05/02/11 08:11, Tom Lane wrote: Wayne Conrad writes: On 04/29/11 12:12, Kevin Grittner wrote: Out of curiosity, what do you get with?: explain analyze select page_number, ps_id, ps_page_id from ps_page p where exists ( select * from documents_ps_page d where d.ps_page_id = p.ps_page_id and

Re: [PERFORM] 8.4.7, incorrect estimate

2011-05-02 Thread Kevin Grittner
Tom Lane wrote: > Wayne Conrad writes: >> Total runtime: 244572.432 ms > I'll take a look at fixing that, but not sure if it'll be > reasonable to back-patch or not. In the meantime, you need to > look into restructuring the query to avoid nesting the EXISTS > probes, if possible. Wayne,

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Greg Smith
On 05/02/2011 12:53 AM, Adarsh Sharma wrote: I am also in need of a proper documentation that explains how to set SHMAX and SHMALL variables in Postgres. What things need to be taken in consideration before doing that ? What is the value of SHMAX & SHMALL if u have 16 GB RAM for Postgres Serv

Re: [PERFORM] 8.4.7, incorrect estimate

2011-05-02 Thread Tom Lane
Wayne Conrad writes: > On 04/29/11 12:12, Kevin Grittner wrote: >> Out of curiosity, what do you get with?: >> >> explain analyze >> select >> page_number, >> ps_id, >> ps_page_id >> from ps_page p >> where exists >> ( >> select * from documents_ps_page d >> where d.ps_page_id = p.ps_page_id >> a

Re: [PERFORM] 8.4.7, incorrect estimate

2011-05-02 Thread Wayne Conrad
Replying to the list this time (oops)... On 04/29/11 12:33, Kevin Grittner wrote: Also, make sure that you run ANALYZE against your temp table right before running your query. I did that, and also added an index to it. That had no effect on the run time, but did fix the estimate for the temp

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Adarsh Sharma
Tomas Vondra wrote: Dne 2.5.2011 06:53, Adarsh Sharma napsal(a): I am also in need of a proper documentation that explains how to set SHMAX and SHMALL variables in Postgres. What things need to be taken in consideration before doing that ? What is the value of SHMAX & SHMALL if u have 16 GB

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Tomas Vondra
Dne 2.5.2011 06:53, Adarsh Sharma napsal(a): > I am also in need of a proper documentation that explains how to set > SHMAX and SHMALL variables in Postgres. > > What things need to be taken in consideration before doing that ? > What is the value of SHMAX & SHMALL if u have 16 GB RAM for Postgre

Re: [PERFORM] The right SHMMAX and FILE_MAX

2011-05-02 Thread Mark Kirkwood
On 01/05/11 18:48, Phoenix Kiula wrote: Now, according to my reading in the PG manual and this list, a good recommended value for SHMMAX is (shared_buffers * 8192) My postgresql.conf settings at the moment are: max_connections = 300 shared_buffers = 300MB effective_cache_siz

Re: [PERFORM] Query improvement

2011-05-02 Thread Claudio Freire
On Sun, May 1, 2011 at 12:23 PM, Mark wrote: > Now the problem. > When I try ANALYZE it shows: That's a regular explain... can you post an EXPLAIN ANALYZE? Hash joins are very inefficient if they require big temporary files. I usually work around that by disabling hash joins for the problematic

[PERFORM] Query improvement

2011-05-02 Thread Mark
Hi I have 3 tables page - revision - pagecontent CREATE TABLE mediawiki.page ( page_id serial NOT NULL, page_namespace smallint NOT NULL, page_title text NOT NULL, page_restrictions text, page_counter bigint NOT NULL DEFAULT 0, page_is_redirect smallint NOT NULL DEFAULT 0, page_is_n

Re: [PERFORM] FUSION-IO io cards

2011-05-02 Thread Justin Pitts
On Fri, Apr 29, 2011 at 10:24 AM, Mark Steben wrote: > Just wondering if anyone has had any experience with this company and these > cards.  We're currently at postgres 8.3.11. td;dr Ask for a sample and test it out for yourself. I asked for, and received, a sample 80GB unit from Fusion to test

Re: [PERFORM] VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?

2011-05-02 Thread Hsien-Wen Chu
Hi Mr. Greg Smith since the block size is 8k for the default, and it consisted with many tuple/line; as my understand, if any tuple/line is changed(maybe update, insert, delete). the block will be marked as dirty block. and then it will be flashed to disk by bgwriter. so my question is if the dat

Re: [PERFORM] pgpoolAdmin handling several pgpool-II clusters

2011-05-02 Thread Tatsuo Ishii
> Can pgpoolAdmin utility handle(administer) more than one pgpool-II custer? No. pgpoolAdmin only supports one pgpool-II server. > We have a need of setting up 3 independent postgres clusters. One cluster > handling cadastral maps, one handling raster maps and one handling vector > maps. Each of