Re: [PERFORM] New server setup

On 10 March 2013 15:58, Greg Smith wrote: > On 3/1/13 6:43 AM, Niels Kristian Schjødt wrote: > >> Hi, I'm going to setup a new server for my postgresql database, and I am >> considering one of these: http://www.hetzner.de/hosting/** >> produkte_rootserver/poweredge-**r720

Re: [PERFORM] New server setup

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 wrote: > On Tue, Mar 5, 2013 at 10:27 AM, Niels Kristian Schjødt < > nielskrist...@autouncle.com> wrote:

Re: [PERFORM] Paged Query

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

Re: [PERFORM] MemSQL the "world's fastest database"?

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 (pgsql-performan

[PERFORM] heavly load system spec

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 1

Re: [PERFORM] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

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: http://www.postgresql.org/mailpref/pgsql-p

Re: [PERFORM] PostgreSQL 9.0.4 blocking in lseek?

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

Re: [PERFORM] Slow cursor

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: http://www.postgresql.org/mailpref/pgsql-p

Re: [PERFORM] Performance problem with a table with 38928077 record

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: http://www.postgre

Re: [PERFORM] Query with order by and limit is very slow - wrong index used

2011/10/4 Nowak Michał : > > 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 > --+---+--

Re: [PERFORM] Query with order by and limit is very slow - wrong index used

2011/10/3 Nowak Michał : >> 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 source_id =

Re: [PERFORM] Query with order by and limit is very slow - wrong index used

How many rows do you have in that table? I think , that planner thinks that the element you are looking for is so common - that it will be to expensive to use index to fetch it. Perhaps try increasing default_statistics_target , and revacuuming the table. You could also try changing it just for t

Re: [PERFORM] PostgreSQL-9.0 Monitoring System to improve performance

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 differen