In my recent experience PgPool2 performs pretty badly as a pooler. I'd
avoid it if possible, unless you depend on other features.
It simply doesn't scale.
On 5 March 2013 21:59, Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Mar 5, 2013 at 10:27 AM, Niels Kristian Schjødt
Use cursors.
By far the most flexible. offset/limit have their down sides.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
It sounds like a lot of marketing BS :)
But I like the fact that they use modern language like C++. It is a
pain to try doing any development on postgresql. Transition to c++
would be nice (I know it's been debated on #hackers a looot).
--
Sent via pgsql-performance mailing list
I know this is a very general question. But if you guys had to specify
system (could be one server or cluster), with sustainable transaction
rate of 1.5M tps running postgresql, what configuration and hardware
would you be looking for ?
The transaction distribution there is 90% writes/updates and
what sort of queries you are running against it ? the select * from..
is not really (hopefully) a query you are running from your php app.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
What does 'select * from pg_stat_activity' say, more precisely - the
waiting column.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Do you really need to query the catalogues ? That on its own is not a
good idea if you want something to run fast and frequently.
--
GJ
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
Do you need left join ?
Can you further normalize the tables? (to lower the I/O)
Can you upgrade to at least 8.3 ? It has huuge performance
improvements over 8.3.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
2011/10/4 Nowak Michał michal.no...@me.com:
a9-dev= select attname, null_frac, avg_width, n_distinct, correlation from
pg_stats where tablename = 'records';
attname | null_frac | avg_width | n_distinct |
correlation
2011/10/3 Nowak Michał michal.no...@me.com:
How many rows do you have in that table?
a9-dev= select count(*) from records;
count
-
3620311
(1 row)
a9-dev= select source_id, count(*) from records where source_id =
'http://ebuw.uw.edu.pl/dlibra/oai-pmh-repository.xml' or
Looks like this is generally an area that can be targeted by some
businesses. Or an open source enthusiast.
One centre that captures all the information and produces a report
based on it would be a great thing. Especially in cases like mine,
where I have tens of postgresql installations on
11 matches
Mail list logo
