>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.
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
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
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,
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
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
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
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
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
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
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
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
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
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
> 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
15 matches
Mail list logo